MSSQLWIKI

Karthick P.K on SQL Server

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

3 Responses to “How to Browse (or) view objects and there code in mssqlsystemresource Database”

  1. I have read so many posts regarding the blogger lovers however this
    article is in fact a good paragraph, keep it up.

  2. 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.

  3. […] How to Browse (or) view objects and there code in mssqlsystemresource Database […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: