opc.three (7/5/2013)
jasona.work (7/5/2013)
might work.It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code, it should not really be trusted. Check out the article I linked to earlier.
True. I had come across that article back when I was starting to dig into MSFForEachDB, and I do like the features he added into his version of the SP.
I guess, the second most common answer to a DBA question applies:
test, test, test in QA, then test again.
😉