Look that the owner and the user are the same. I need to know what is the correct configuration I have to do.
Asked
Active
Viewed 39 times
-3
-
3Please, don't post images like that. – Emanuele Jun 30 '21 at 17:03
1 Answers
0
this is not owner , you are referring to schema.
sql server had "dbo" as It's default schema for all the user ,
however you can change the default schema for user permanently
using :
ALTER USER userName WITH DEFAULT_SCHEMA = { schemaName | NULL }
but I recommend , you always use schemanaem.objectname to avoid further issues

eshirvana
- 23,227
- 3
- 22
- 38