Ignorance is not always a bless… In this case, it took us a lot of time figuring out why wasn’t the default schema kicking in. This one is well documented:
The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of
dbo.
No comments:
Post a Comment