SQL Search tool searching for data

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

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

SQL Search tool searching for data

Postby bsanta » Fri Nov 09, 2012 12:34 am

Hello,

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.

Thanks.[/i]
bsanta
 
Posts: 1
Joined: Fri Nov 09, 2012 12:28 am

Postby Brian Donahue » Fri Nov 09, 2012 10: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests