Just sharing some of my inconsequential lunch conversations with you... RSS  

Thursday, November 12, 2009

SQL Server ignored default schema

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:

Development Catharsis :: Copyright 2006 Mário Romano