SQL Search tool searching for data

A free Management Studio add-in to search for SQL in your databases

SQL Search tool searching for data

Postby bsanta » Thu Nov 08, 2012 11:34 pm


Does anyone know if SQL Search tool allows for searching for data within tables?? I have tried this but have been unsuccessful. It only looks at objects such as procedures, triggers, etc. But I haven't been able to find a way to search for data. Any help would be greatly appreciated.

Posts: 1
Joined: Thu Nov 08, 2012 11:28 pm

Postby Brian Donahue » Fri Nov 09, 2012 9:14 am

SQL Search is for searching DDL text, so it will search the metadata in the database but not the actual data in tables. You could try this stored procedure from MS...

http://gallery.technet.microsoft.com/sc ... 31fe641c58
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Search Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests