SQL Server Home
sp_MSForEachDB : Provide supported, documented version
as Won't Fix
3/22/2007 6:25:40 AM
This stored procedure is undocumented and unsupported, but its use is rampant.
Document and support it, or create a version that you can document and support.
I'm not sure of the exact threshold, but I've had cases where handfuls of databases are completely skipped on systems with > 255 databases.
Of course I don't expect a fix to an undocumented procedure, but I've had to write my own, which I've found much more reliable, so perhaps Microsoft could consider doing the same and making it an official part of the offering.
to post a comment.
Please enter a comment.
on 9/2/2007 at 10:28 PM
Thank you for reporting the issue. It is our general policy not to provide documentation to internal unsupported API like this one.
MS SQL Server Team
to post a workaround.
Please enter a workaround.
© 2014 Microsoft