June 17, 2009 at 12:13 am
Hi,
I need to search a keyword from all databases using sql query or procedure.
(Ex: Suppose if i give search value as India means it should search all databases and in all tables in sqlserver)
June 17, 2009 at 12:45 am
http://qa.sqlservercentral.com/scripts/Miscellaneous/65769/
This should provide a starting point - it only searches one database.
June 17, 2009 at 12:59 am
Thanks yaar...
But my specification is to Search value from all databases.
June 17, 2009 at 2:49 am
Just another script:
http://qa.sqlservercentral.com/scripts/anywhere/66000/
To search in all databases just add a loop through databases around the tables part.
Flo
How to Post Data/Code to get the best Help How to Post Performance Problems
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply