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
table name qualifiers
-
alexa
Re: table name qualifiers
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.