search every database on server from a single sp

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chris Morton » search every database on server from a single...

search every database on server from a single sp

Rate Topic

Display Mode

Topic Options

Author

Message

kodracon

Posted Wednesday, November 12, 2008 7:26 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

Comments posted to this topic are about the item search every database on server from a single sp

Post #601813

jfernando

Posted Friday, December 19, 2008 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 11, 2010 11:17 AM
Points: 2, Visits: 25

Hi Chris

when I run the sp I am getting the following error am i missing any thing

Msg 208, Level 16, State 6, Procedure findnumber, Line 191
Invalid object name 'dbo.findnumber'.

also if you can send me the missing part search the columns feature it would be helpful cause we are also need such a sp to our work

thanks

Jim

Post #623038

kodracon

Posted Friday, December 19, 2008 11:20 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

Hi jim
u should find the find number stored procedure in the master table

try this:

use master
findnumber '%123456%'

i am not sure what you mean in the second part of your question.

Thanks

Chris

Post #623211

jfernando

Posted Friday, December 19, 2008 12:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 11, 2010 11:17 AM
Points: 2, Visits: 25

Hi Chris

I got the findnumber issue fixed

I mention in the artical you said that you have exclude the part checking if it contains the right columns

you can send me that part to my email jim.fernando@gmail.com if you like to share it with me.

Thanks

Jim

Post #623259

kodracon

Posted Tuesday, December 30, 2008 11:13 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

will do so in the new year

Post #627825

Eralper

Posted Monday, April 20, 2009 2:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 01, 2012 6:49 AM
Points: 178, Visits: 463

Hello,
I think we can also handle this taks by using the sp_MSForEachTable and sp_MSForEachDB un-documented stored procedures .

Eralper
SQL Server and T-SQL Tutorials and Articles
Microsoft Certification and Certification Exams

Post #700435

« Prev Topic | Next Topic »

Permissions