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
Pro.name As ProcedureName
From
sys.procedures Pro
Inner Join
sys.schemas Shma
ON
Pro.schema_id = Shma.schema_id
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
Pro.name As ProcedureName
From
sys.procedures Pro
Inner Join
sys.schemas Shma
ON
Pro.schema_id = Shma.schema_id
No comments:
Post a Comment