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/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Adrian00]

Go beyond full text search. Search SQL Server database data for anything without writing queries, no setup, Google-like. Search results can be replaced, removed, saved and shared with others. SQLLocator.com
_________________
http://www.cdl-practicetest.com/Georgia-cdl-practice-test.htm
http://www.cdl-practicetest.com/Louisiana-cdl-practice-test.htm
http://www.cdl-practicetest.com/Tennessee-cdl-practice-test.htm
http://www.cdl-practicetest.com/