How to Browse (or) view objects and there code in mssqlsystemresource Database
Posted by Karthick P.K on January 15, 2009
How to Browse (or) view mssqlsystemresource Database.
1. Stop the SQL Server service
Copy the mssqlsystemresource.MDF and mssqlsystemresource.LDF to a new path (This
two files will be in same path where master databse is located).
Start the SQL Server Service
Ues the following command to attach the data and log file as a new user database.
EXEC sp_attach_db
‘mssqlsystemresource _Copy’, ‘<Path where you copied>\resource_copy.mdf’,
‘<Path where you copied>\resource_copy.ldf’
Now you browse through all the system objects and there code.
OR
1. Start SQL Server in single user mode.
2. Open SSMS and connect using DAC (ADMIN) Connection and change DB context to “mssqlsystemresource”.
use mssqlsystemresource
3. Query Resource DB objects.
Regards
Karthick P.K
MSSQLWIKI 
michael kors said
I have read so many posts regarding the blogger lovers however this
article is in fact a good paragraph, keep it up.
anabolic cooking said
There is nothing like coming home after a day out to the smell of
something cooking and knowing your dinner is almost ready.
Keep in mind that the greater the heat isn’t usually
the greater. I hope this Wo – W Cooking Level Guide has served you get a greater perception of
the wow cooking occupation.
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] How to Browse (or) view objects and there code in mssqlsystemresource Database […]