Re: sql2k5 schema qualifier
- From: Dave Joyner <d4ljoyn@xxxxxxxxx>
- Date: Sun, 18 Jun 2006 12:26:41 -0400
Thank you. I looked at this again and it is something else that we changed during the migration. What is now the schema MIS_TABLES used to be owner dbo. Duh.
Kalen Delaney wrote:
Hi Dave.
If you do not specify a schema name, SQL Server will look in your default schema, then in the dbo schema.
This is very similar to what we happens in SQL Server 2000, in that unqualified objects are first checked to see if they are owned by the current user, then checked to see if they are owned by dbo.
Roles, permissions,etc do not help determine what schemas to check.
The reason is that there can be objects of the same name in different schemas (or in SQL 2000, owned by different users).
What if MIS and MIS_TABLES both included a table named foo_bar? Which one would you want?
Can you explain what behavior you saw in SQL 2000 that makes you say it was easy?
- References:
- sql2k5 schema qualifier
- From: Dave Joyner
- Re: sql2k5 schema qualifier
- From: Kalen Delaney
- sql2k5 schema qualifier
- Prev by Date: Re: sql2k5 security
- Next by Date: Re: database encryption
- Previous by thread: Re: sql2k5 schema qualifier
- Next by thread: Log queries made through SQL manager only ?
- Index(es):
Relevant Pages
|
