venkatesh.koolla' s

About Microsoft.Net Technologies and DataBase related Topics

Tuesday, March 7, 2017



Query to search on specific string in database procedures

select name,OBJECT_DEFINITION(object_id) from sys.procedures
where OBJECT_DEFINITION(object_id) like '%With(Index%'
Posted by venkatesh koolla at 11:19 AM

No comments:

Post a Comment

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

My Blog List

  • Journey to SQL Authority with Pinal Dave
    SQL SERVER Performance – JSON vs XML
    5 weeks ago
  • Tricks on SQL Server and .NET Technologies...!
    .NET Interview questions for experiences by another blogger Pavan
    10 years ago

Emails

  • Hotmail
  • Yahoo
  • Gmail

Blog Archive

  • ▼  2017 (6)
    • ►  May (2)
    • ▼  March (3)
      • Difference between Read Uncommitted and Nolock -...
      • Query to search on specific string in database ...
      • SQl Query to find out the unused Indexs in SQl s...
    • ►  February (1)
  • ►  2012 (3)
    • ►  January (3)
  • ►  2010 (3)
    • ►  July (2)
    • ►  April (1)
  • ►  2009 (27)
    • ►  September (2)
    • ►  July (3)
    • ►  June (10)
    • ►  May (4)
    • ►  April (1)
    • ►  March (1)
    • ►  February (5)
    • ►  January (1)
  • ►  2008 (10)
    • ►  December (1)
    • ►  November (4)
    • ►  October (2)
    • ►  September (3)

Favorites

  • Convert.Docx file to .Doc file
  • http://venkateshkoolla.com

moody, crazy, and mad.........

venkatesh koolla
Bangalore, South India, India
Dont know still
View my complete profile