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://www.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://www.sqlservercentral.com/scripts/anywhere/66000/
To search in all databases just add a loop through databases around the tables part.
Flo
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply