Comments posted to this topic are about the item search every database on server from a single sp
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
u should find the find number stored procedure in the master table
i am not sure what you mean in the second part of your question.
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 email@example.com if you like to share it with me.
will do so in the new year
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 5 (of 5 total)