Solved

Could not find stored procedure 'spMsForEachDb'.

Posted on 2010-08-20
4
446 Views
Last Modified: 2012-05-10
what is causing the above error, even though I have mentioned the ? to get every db, in the foll?

exec spMsForEachDb 'select db_name(),Table_name from  [?].INFORMATION_SCHEMA.COLUMNS where table_name = ''TrackerCode'''

thanks.
0
Comment
Question by:anushahanna
4 Comments
 
LVL 6

Assisted Solution

by:Patrick Tallarico
Patrick Tallarico earned 50 total points
ID: 33489437
Do you get the same error with the following code?
use master
go
exec spMsForEachDb 'select db_name(),Table_name from  [?].INFORMATION_SCHEMA.COLUMNS where table_name = ''TrackerCode'''
0
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 50 total points
ID: 33489456
try use master
go
exec spMsForEachDb 'select db_name(),Table_name from  [?].INFORMATION_SCHEMA.COLUMNS where table_name = ''TrackerCode'''

the ''TrackerCode'' are singles
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 400 total points
ID: 33489542
sp<underscore>msforeachdb
..
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33489585
Thanks experts.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now