Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Search value in the whole database

Author  Topic 

linda9898
Starting Member

28 Posts

Posted - 2007-09-10 : 12:52:26
Hi,

i am investigating data base and try to find conections between tables with keys.
so for example if i found value of '1' i want to make search in the database for all tables and all coloumns to bring me back all the values '1' with its table.
does anyone know a function for it ?
i know its a nasty one but pls try to help.

Thnx,
Linda

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 12:53:53
This will do it:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm




Future guru in the making.
Go to Top of Page
   

- Advertisement -