Wednesday, October 29, 2008

Find a Specific Value Anywhere in a SQL Server Database

I can't tell you how often in the past I could have used this script from David Yardy:
http://blog.davidyardy.com/archive/2008/08/16/sql-server-ndash-find-field-value-in-database.aspx
I can find a string value anywhere it exists in a field in my database. As he says, it can easily be modified to search for values that are not strings.

1 comment:

david said...

Thanks for the referral. - david y