search every database on server from a single sp

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

jfernando SSC Rookie Points: 42 More actions · Answer 1

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

kodracon Ten Centuries Points: 1027 More actions · Answer 2

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

jfernando SSC Rookie Points: 42 More actions · Answer 3

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

kodracon Ten Centuries Points: 1027 More actions · Answer 4

Ten Centuries

Points: 1027

December 30, 2008 at 11:13 pm

will do so in the new year

Eralper SSCarpal Tunnel Points: 4438 More actions · Answer 5

Hello,

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