question

manoj123 avatar image
manoj123 asked

How to find user defined objects created on master database in sql server 2000?

How can I find user defined store procedure created the in master database in sql server 2000? select * From sysobjects where type in ( 'IF', 'P', 'RF', 'TF', 'TR' , 'U', 'V', 'X' ) I have tried to use this but I am getting all the system sp . How can I filter them
sql-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
I would have a look at also filtering on the [`sysobjects` table's `crdate`][1] field - look for objects created after your installation was done. [1]: http://technet.microsoft.com/en-us/library/aa260447(v=sql.80).aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

manoj123 avatar image manoj123 commented ·
Thank you Thomas for the reply and I will check it on Monday
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.