XploreDotNet
Known Is A Drop,UnKnown Is An Ocean....
Njoy Programming
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Loading...
No comments:
Post a Comment