Some time i have to extract all procedure from out SQL Server Database. For example i have to delete all procedures from the database then first i have to get all the procedure name & execute the command with drop.Then here some query to extract the all procedure from SQL server database. All query is tested on SQL Server 2008 version.
Code Sample [SQL Server Query]
SELECT * FROM sys.objects where type='p'
SELECT * FROM sys.procedures
Note : All query tested in SQL Server 2008R2
If you want to get some specific procedures name however you remember partially procedure name .Then Query is
read more..
0 comments:
Post a comment