• 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


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/