search every database on server from a single sp

  • kodracon

    Ten Centuries

    Points: 1027

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

  • jfernando

    SSC Rookie

    Points: 42

    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

    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

    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

    will do so in the new year

  • Eralper

    SSCarpal Tunnel

    Points: 4438

    Hello,

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

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

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