Thursday, September 22, 2011

How to get all stored procedures in database ?

 some times we need to know which stored procedure we are using for a single database and for that we need to note down all stored procedure name. Its takes lot of time and passions i am also faced this time of problem so many times . So i decided to looking for a better option so can we get the stored procedures name very easily
 And finally i found this query which returns stored procedure  name from the database.

 Here is the query to get all stored procedures in the database

Select As ProcedureName
   sys.procedures Pro
Inner Join
   sys.schemas Shma
   Pro.schema_id = Shma.schema_id

No comments:

Post a Comment