table name qualifiers

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
bbcgsci
Posts: 1
Joined: Thu 30 Aug 2012 19:57

table name qualifiers

Post by bbcgsci » Thu 30 Aug 2012 20:17

I have unchecked "Include default schema (dbo) in object name", but SQL Complete always puts the dbo. qualifier on my table names on some of my servers. Any ideas of why and how I can tell it to never use the dbo. qualifier?

Thanks,
BB

alexa

Re: table name qualifiers

Post by alexa » Fri 31 Aug 2012 11:02

Please make sure on these servers dbo is set as a default schema for this user. Otherwise, if the default schema for this user is not dbo, the dbo prefix will be always added despite the 'Include default schema (dbo) in object names' option is unchecked.

Post Reply