I wish there are existing workaround. =(

If i have this SP:

--

CREATE PROC usp_SimpleSP

AS

BEGIN

SELECT

[EmployeeID] = 13,

[Name] = 'Some name',

[Age] = 20,

[Deleted] = 0

END

--

What I want is, a script that will return its column name such :

"EmployeeID", "Name",...

I tried using:

select * from

INFORMATION_SCHEMA.PARAMETERS

but its only return the SP Parameters. but no SP Column(s) Name.

What i want is to List all the Column Name of a specific SP. =)

ramesh or any one,

can you convert to sql 2000? =)

SELECTo.name, o.type_desc, p.name, t.name, p.max_length, p.precision, p.scale, p.is_output, p.is_cursor_ref, p.has_default_value, p.is_xml_document, p.default_value FROM sys.all_objects oinner join sys.all_parameters p on o.object_id =...