Tuesday, March 31, 2009

how to find the list of stored procedure in the database






Sql Server 2005

SELECT * FROM sys.procedures;


User Procedure

SELECT * from sys.objects where type='p' and is_ms_shipped=0 and [name] not like 'sp[_]%diagram%';



No comments:

Creative Commons License
Disclaimers:We have tried hard to provide accurate information, as a user, you agree that you bear sole responsibility for your own decisions to use any programs, documents, source code, tips, articles or any other information provided on this Blog.