• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1281
  • Last Modified:

Query an Entire Database for a string

I heard that in SQL Server 2k5 you could query an entire database for a phrase say 'XYZ' if that is true, does anyone know how to do it ?
0
Auerelio Vasquez
Asked:
Auerelio Vasquez
1 Solution
 
rickchildCommented:
Check out this procedure, it will search all string fields in all tables in a database for a 'XYZ'

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now