Solved

Could not find stored procedure 'spMsForEachDb'.

Posted on 2010-08-20
4
449 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

919 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

15 Experts available now in Live!

Get 1:1 Help Now