I forgot to get add the code for the custom function ufn_quotestring() found at http://www.sommarskog.se/dynamic_sql.html

CREATE FUNCTION [dbo].[ufn_quotestring](@str nvarchar(1998)) RETURNS nvarchar(4000) AS

BEGIN

DECLARE @ret nvarchar(4000),

...

Thanks winash,

I've adapted your solution to SQL Server 2000 and made it so that it could use any stored procedure and it seems to work great. This is definitely...

Thanks John,

SSIS and many other client applications read the information into a recordset and then process it in a programming language other than SQL to get the column names. ...

It is kind of convoluted, but what do you all think of returning the results as XML then querying that XML for the column data? I have been trying...

Thanks, I tried this, but it only gets me the same result set without any data. If I run this through a query tool then I see the column...