December 23, 2010 at 9:24 am
Hi,
We recently changed the ownership of all tables from dbo to another existing login. Since the change, I must now precede the table name with the name of the new owner whenever I create a query in SQL Server Management Studio (2008), even though the default database is set correctly. Other folks in my group are not required to do this even if we use the same login for SQL Server Management Studio. I'm thinking this must be a personal setting for the Management Studio on my computer but I can't find a setting that would apply to this problem.
Does anyone know of a default setting the would specify the table owner so I don't have to when I create a query?
Thanks for any help you can give,
TJ
January 5, 2011 at 11:39 pm
As a sanity check, ensure that the 'Default schema' in the database for your login does not say dbo, but rather the new table owner you set. The only reason I could think that others are not having the issue is that you or they are not connecting to the same database in the same SQL instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply