Finding Data in SQL Database - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Finding Data in SQL Database

Author

Topic

yalgaar
Starting Member

43 Posts

Posted - 2006-02-23 : 11:36:55

I have like 20 databases on my SQL Server. I have like 30 tables in each Database. I would like to find out all the rows in all tables in all database that has a certain text?

Is this possible?

Thanks in Advance
Yalgaar

yalgaar
Starting Member

43 Posts

Posted - 2006-02-23 : 12:28:34

Anybody??

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-23 : 17:46:35

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

----------------------------------
'KH'
It is inevitable

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources