1

My question might sound stupid, but does there exist a script that could find out where in database, for which tables, is the desired data located? Say for example, i need to found where Texas is located in database, in which tables and in which column.

There exists a script that could find out the tables, SP, views based on the column name provided. Is there any script that could find out tables, column name etc based on the actual data?

Hope the question is understood.

Best Regards

xorpower
  • 17,975
  • 51
  • 129
  • 180

3 Answers3

3

Josh Walker has a script that will find the number of incidences a string of text is found, and in which tables:

http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

And, this statement should find any procedure code that contains the text you are looking for:

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%whatever%'
NTDLS
  • 4,757
  • 4
  • 44
  • 70
Seth Delconte
  • 46
  • 2
1

The SSMS Tools Pack gives you this kind of search functionality plus various other cool things for free. And no, I don't work for them!

Simon
  • 6,062
  • 13
  • 60
  • 97
  • SSMS tools pack just rocks!!!! Aware about any such other free tool which could provide some rocking out-of-the-imagination functionality – xorpower Nov 28 '11 at 07:45
0

I have got one great tool that can find data anywhere located in the database. It is known as SQL Locator. Just Google it, that should be easy to find. Plus it is a freeware to download.

Thanks!

xorpower
  • 17,975
  • 51
  • 129
  • 180