Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Search All Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 12:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 4:36 AM
Points: 36, Visits: 54

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)
Post #736239
Posted Wednesday, June 17, 2009 12:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:48 AM
Points: 1,533, Visits: 7,916
http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

This should provide a starting point - it only searches one database.


BrainDonor
Linkedin
Blog Site
Post #736247
Posted Wednesday, June 17, 2009 12:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 4:36 AM
Points: 36, Visits: 54

Thanks yaar...
But my specification is to Search value from all databases.
Post #736251
Posted Wednesday, June 17, 2009 2:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, Visits: 3,932
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



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #736292
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse