stored procs in Master db, sql server 2005
Home > IT Answers > SQL Server > stored procs in Master db, sql server 2005
GillsJules
5 pts.
0
Q:
stored procs in Master db, sql server 2005
SQL Server stored procedures, SQL Server 2005, T-SQL
Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored prodedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers
ASKED: May 12 2009  3:49 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Did you check Microsoft documentation? I remember that there was a sp that listed all basic information on the stored procedure but can't remind it right away.

You can get a list of stored procedures by querying the sys.procedures catalog view. You can use the sp_helptext procedure to get the contents of each procedure.
Last Answered: May 16 2009  1:02 AM GMT by Mrdenny   46795 pts.
Latest Contributors: Alessandro.panzetta   9615 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0