Re: SQL2005 sys tables
- From: "Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 16:27:56 -0800
In SQL Server 2005, system objects are stored in a new system database
called the Resource database. System metadata is exposed to users in
catalog views.
In general, there is an equivalent catalog view for every system table. So,
instead of querying the sysusers table, you should query the sys.users
catalog view.
Another important change related to system metadata is that in SQL Server
2005, the visibility of metadata is limited to securables that a user either
owns or on which the user has been granted some permission. In earlier
versions, metadata was visible to members of the public role (meaning,
anyone with access to the db).
I recommend the following Books Online topics to get you up-to-speed on
these changes.
Resource Database
Catalog Views (Transact-SQL)
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Querying the SQL Server System Catalog FAQ
Metadata Visibility Configuration
Regards
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"mecn" <mecn2002@xxxxxxxxx> wrote in message
news:uEK5Zo3UGHA.5552@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
In sql2005, I don't a lot of sys tables in master db.
i.e. sysusers and syslogins?
ANy ideas?
Thanks
.
- References:
- SQL2005 sys tables
- From: mecn
- SQL2005 sys tables
- Prev by Date: Sql2k sp4 sql user password
- Next by Date: Re: Error 823
- Previous by thread: SQL2005 sys tables
- Next by thread: Re: SQL2005 sys tables
- Index(es):
Relevant Pages
|
