开发者

Queries Always Require Table Name to be Preceded by Owner

We recently changed the ownership of all tables from dbo to another existing login(user). 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 t开发者_开发技巧he would specify the table owner so I don't have to when I create a query?

Thanks for any help you can give,

TJ


You can specify a default schema for a database user not linked to a windows login/group.

Otherwise, it's best practice to qualify objects with schema anyway. This helps execution plan re-use because object references are unambiguous.

Rather then explain here, some references: one, two, three

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜