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)
 search on all tables data in database

Author  Topic 

HadiMMM
Starting Member

5 Posts

Posted - 2011-01-23 : 04:42:13
hi.
i cant speak english very well.
i want search data in all tables in one database.
for example search data 12 on all tables in database.
what can i do this?
thank you.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-01-23 : 07:16:30
Install SSMS Toolspack from http://www.ssmstoolspack.com
This tool will make it possible and so much more.



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-01-24 : 02:59:22
or
http://beyondrelational.com/blogs/madhivanan/archive/2009/12/14/search-a-value-in-character-column-of-all-tables.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -