sp_MSForEachDB

[DBAWinnipeg]

This neat little stored procedure used to be on SQL 6.5 I think... and I haven't seen anything similar in 2000... is there such a function or does someone have a cursor/code they've developed for running a script on multiple databases?




Thanks in advance!!!

Colin in da 'Peg

 

[ClaireHCM]

You could also call this stored proc in SQL 2000 and SQL 7.0, it's a very famous undocumented stored proceudure.

 

[DBAWinnipeg]

sp_MSForeachdb

it appears "red" in a query analyzer window but I get this message

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_MSForeachdb'.

Ideas?

Thanks in advance!!!

Colin in da 'Peg

 

[JayKusch]

Should be in the Master DB

Thanks

J. Kusch

 

[DBAWinnipeg]

Thanks everyone

 

[ClaireHCM]

sp_MSForEachDb resides in Master database, sometimes due to company policy they would remove this kind of stored procedure. Because it's so powerful, some inexperienced IT staff may mis-use it.

Check out Object browser to see whether this stored procedure still exists or not.