Thursday 2 April 2015

Get List of Stored Procedures Tsql

To get a list of sprocs(Stored Procedures) from SQL run the following

select *
  from Database Name .information_schema.routines
 where routine_type like 'Procedure'

Replace Database Name  with you Database name.

No comments:

Post a Comment

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...