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 2008 Forums
 Transact-SQL (2008)
 SQL Help

Author  Topic 

tooba
Posting Yak Master

224 Posts

Posted - 2012-09-27 : 13:35:51
Hi Guys,

I have quick question, is there any way or any one can help me or provide me the way to find a specific
data in the whole database tables? I.e My data is " Andi" but i don't know the table name and column name.

Thanks in Advance.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-09-27 : 13:44:03
See if this will help you: http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx
Go to Top of Page
   

- Advertisement -