Page 1 of 1

table name qualifiers

Posted: Thu 30 Aug 2012 20:17
by bbcgsci
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

Re: table name qualifiers

Posted: Fri 31 Aug 2012 11:02
by alexa
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.