Adi Cohn (1/9/2009)
i got it wrong, missed mssqlsystemresource, mainly because im a 2005 user.
Actually the mssqlsystemresource was introduced at SQL Server 2005
Yes the system databases in SQL Server 2005 are
Resource Database = mssqlsystemresource!
So the user just see the information about Resource Database, not also that this resource db name is "mssqlsystemresource"
Anyway the Resource Database is a read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database.
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =http://www.sqlservercentral.com/articles/Best+Practices/61537/