Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-04-26 : 15:46:48
|
| Hi,I have active directory login/user in 10 databases. When I checked default schema for this user it shows null. I want to change default schema for this user/login in all databases as dbo. When I right click on user in database and change deault schema to dbo. It changed but when I check again this field is empty and through query it shows null. Please help. Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-26 : 15:58:35
|
| When I try to change with this command: alter user <username> with default_schema=dbo I get following error:The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys. |
 |
|
|
|
|
|
Default Schema