anushahanna
asked on
Could not find stored procedure 'sp_msforeachtable'.
This is a SQL 2005 database? How can I verify if it is a syntax error or if the SP is indeed missing the database?
thanks
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
run the query:
select * from sys.all_objects where [name] like 'sp_MSforeach%'
on master
select * from sys.all_objects where [name] like 'sp_MSforeach%'
on master
ASKER
x-men,
I just saw this response. Thanks. It is even simpler.
I just saw this response. Thanks. It is even simpler.
ASKER