Friday, 3 April 2015

List all the stored procedures User created by SQL query.?

select * from information_schema.routines where routine_type = 'PROCEDURE'
and Left(Routine_Name, 3) NOT IN ('sp_', 'xp_', 'ms_','dt_')
or

select * from sys.procedures where is_ms_shipped = 0

No comments:

Post a Comment