Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

search every database on server from a single sp Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 7:26 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:52 PM
Points: 55, Visits: 157
Comments posted to this topic are about the item search every database on server from a single sp
Post #601813
Posted Friday, December 19, 2008 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, December 19, 2008 11:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:52 PM
Points: 55, Visits: 157
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
Posted Friday, December 19, 2008 12:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, December 30, 2008 11:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 9:52 PM
Points: 55, Visits: 157
will do so in the new year
Post #627825
Posted Monday, April 20, 2009 2:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 24, 2013 1:55 AM
Points: 178, Visits: 465
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 »

Add to briefcase

Permissions Expand / Collapse