shy.n86 (7/6/2013)
Hi Geeks,I have question about usage of this SP that how legal it is use to use this sp?
what kind of impact it does on your sever when a statement with this sp is fired? I mean does it have any negative impacts on using this SP, since it comes under undocumented SPs.
Thank you!
I don't think that using this SP is "illegal"
It would not be advisable to use such SP's in Production code, but for ad-hoc requests I don't see any harm using this procedure
You can check the code of the procedure under master->Programmability->Stored Procedures->System Stored Procedures->sp_MSforeachdb
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/