Once again my mind has been blown ^_^

For some reason I was under the impression that using SET NOCOUNT ON didn't have an affect on procedures, as in, if I...

Okay, if SET NOCOUNT ON is not specified for a procedure the SET FMTONLY OFF still does not resolve the issue.

Again, since there will be 2500+- predefined SPs to go...

My mind has just been blown..

The solution in there seems to be using 'SET FMTONLY OFF' before the execute statement in OPENROWSET or OPENQUERY, which I had tested extensively (or...

Also, if a local temp table is created outside of the EXEC statement it can be referenced within one like so:

DECLARE @sql VARCHAR(MAX)

IF(OBJECT_ID('TempDB..#TempOutput') IS NOT NULL) DROP TABLE #TempOutput

CREATE TABLE...

Stewart, I think I agree, but the purpose of this utility is to catalog the output columns of procedures without having prior knowledge of said output. I had hoped...

Stewart, the method you propose requires me to know the output of a procedure in advance, does it not?

ChrisM, I am indeed working on one single server.

Okay.. I've given up and gone back to my old friend xpcmdshell. Throughout this response and its code the underscore (_) will be implied for xpcmdshell as I often...