sql server management tools

I use  sql server management 2008 and try to get all the existing stored procedures.
I go to stored procedure folder and only see system stored procedures...
where can I view /modify all of the existing sp?
Who is Participating?
Rich WeisslerConnect With a Mentor Professional Troublemaker^h^h^h^h^hshooterCommented:
I think the procedures you are looking for would be in the mssqlsystemresource database (usually just refered to as the Resource database.)  That database is normally hidden.  You can (not recommended) make a copy of the database, and attach to that copy to read it's procedures.

Or did you mean the procedures custom to a specific database?
So when you go to [DatabaseName] -- [Programmability] -- [Stored Procedures] only teh system stored procedures are showing.  This could mean that your userid does not have permmissions to the stored procedures.  One way would to check the user permssions at the database lvl to see what role(s) and securable level permissions are configured.
Webboy2008Author Commented:
And you are sure that database does have stored procedures?
Did any of the solutions proposed help you with this original question?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.