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%';
|
|
|
|
Known Is A Drop,UnKnown Is An Ocean....
Njoy Programming
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%';
|
|
|
Related Posts : HowTo,
SQL Server
|
|
|
Labels: HowTo, SQL Server Posted by windows_mss at 3/31/2009
|
|
|
0 comments:
Post a Comment