SQLSolutions and SSIS

Thursday, March 6, 2014

Find some text in stored procedure

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%upperquart%'
ORDER by OBJECT_NAME(object_id)

Posted by MySql at 2:35 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (3)
    • ►  July (3)
  • ▼  2014 (24)
    • ►  December (2)
    • ►  November (2)
    • ►  September (1)
    • ►  August (1)
    • ►  April (1)
    • ▼  March (8)
      • Step By Step SQL Server Log Shipping
      • Difference between LOG SHIPPING VS. MIRRORING VS. ...
      • Difference between SQL Server 2012 AlwaysOn vs. Da...
      • Configure SQL Server Database Mirroring Using SSMS
      • Installing SQL Server 2012 in a Mirror Setup
      • MS SQL Server 2012 - Database Mirroring Setup - us...
      • Find some text in stored procedure
      • SQL Server CROSS APPLY and OUTER APPLY
    • ►  February (1)
    • ►  January (8)
  • ►  2013 (123)
    • ►  December (20)
    • ►  November (1)
    • ►  October (8)
    • ►  September (48)
    • ►  July (7)
    • ►  June (10)
    • ►  May (11)
    • ►  April (16)
    • ►  January (2)
  • ►  2012 (1)
    • ►  December (1)

About Me

MySql
View my complete profile
Awesome Inc. theme. Powered by Blogger.