How can we help you today? How can we help you today?

SQL Search tool searching for data

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
0

Comments

2 comments

Sort by
  • 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
    Brian Donahue
    0
  • 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.   >:-{
    CoachGJ
    0

Add comment

Please sign in to leave a comment.