We help IT Professionals succeed at work.

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?
Watch Question

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.
Professional Troublemaker^h^h^h^h^hshooter
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?


Most Valuable Expert 2012
Top Expert 2014

And you are sure that database does have stored procedures?
Did any of the solutions proposed help you with this original question?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.