How to find all the Stored Procedures having a given text in it?

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE  ROUTINE_TYPE='PROCEDURE'

Comments

Post a Comment

Popular posts from this blog

To send automatic email window  services http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-ii/
Read more
Cart URL http://demo.opencart.com/admin/index.php?route=catalog/product&token=e1ce5583d537727fce5af2d43e894c50   http://www.cs- cart .com/demo- item.html http://discover.store.sony. com/tablet/#specs/diagram   http://www.bit- cart .com/ shopping- cart -live-demo.html
Read more
Difference Between  @@identity , scope_identity() and ident_Current('tablename'):-  SELECT @@IDENTITY @@IDENTITY is limited to the current session, it is not limited to the current scope. SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT(‘tablename’) IDENT_CURRENT is not limited by scope and session; it is limited to a specified table.    
Read more