sp_Find2

  • shahgols

    SSCrazy Eights

    Points: 9869

    Comments posted to this topic are about the item sp_Find2

  • magnus.eklof

    Newbie

    Points: 5

    It was prob a little fast in the making... in the comments it says sp_Find4, and whole chunks was missing from the 'else' statement I noticed it did not search tables or columns if you selected a specific DB... anyway I tweaked it and now I am happy.

  • calgeorge

    Old Hand

    Points: 336

    This proc crashes if there any database offline -

    Msg 942, Level 14, State 4, Line 2

    Database 'db1' cannot be opened because it is offline.

  • Nadrek

    SSC-Insane

    Points: 20039

    magnus.eklof (5/10/2012)


    It was prob a little fast in the making... in the comments it says sp_Find4, and whole chunks was missing from the 'else' statement I noticed it did not search tables or columns if you selected a specific DB... anyway I tweaked it and now I am happy.

    Could you please post your modified version? One of us can do the database state modification on the corrected version.

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

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