SQL Search tool searching for data

bsanta

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]

Brian Donahue

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

CoachGJ

I had the Old Version on SQL Server 2014 for years and it searched both values and objects/fields. This newer version  only returns fields and objects.   >:-{