Oh man...I ran sql server SP2 and now I'm in trouble:
I have tons of code that's referencing Tables and SPs via ADO and VB...we're
talking 3 years of apps and applets...
Before the SP2, if a table owner was connected, my SQL queries did not have
to specifically reference Table objects owned by that owner by owner name.
ie: "Select * from TableName" USED to work, EVEN if TableName was owned by,
say Bob, as long as Bob was connecting.
Since SP2.... when Bob is connected, ADO can't find the table, unless I
reference the owner: "Select * from Bob.TableName"
I've learned that its best to have DBO own objects, so I do that from now
on, but I've got 100s of tables and procedures and 100s of apps that
reference tables without the full qualifier. Is there anything I can do,
short of uninstalling SP2, or changing all my apps, that will allow BOB to
see BOB's tables without referencing Bob.Tablename? There's got to be some
SQL setting that allows this?