Search

sp_MSForEachDB : Provide supported, documented version by aaronbertrand

Closed
as Won't Fix Help for as Won't Fix

12
2
Sign in
to vote
Type: Suggestion
ID: 264677
Opened: 3/22/2007 6:25:40 AM
Access Restriction: Public
0
Workaround(s)
This stored procedure is undocumented and unsupported, but its use is rampant.
Details (expand)
Product Language
English

Category

SQL Engine

Proposed Solution

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.

Benefits

Faster Development
Improved Administration

Other Benefits

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 9/2/2007 at 10:28 PM
Hello aaronbertrand,

Thank you for reporting the issue. It is our general policy not to provide documentation to internal unsupported API like this one.

Regards,
MS SQL Server Team
Sign in to post a workaround.