I am trying to create a stored procedure on SQL server 2000 that returns a recordset for a cursor (in another stored procedure).

I know how to do it as an output parameter but I want to do it like I would return a recordset for VB.

i.e.

'CREATE PROCEDURE GetRS() AS
SELECT * FROM t_Table'

And not:

'CREATE PROCEDIRE GetRS(@rsTable CURSOR VARYING OUTPUT) AS
SET @rsTable = CURSOR FOR
SELECT * FROM t_Table
OPEN @rsTable'

Does anyone know if this is possible?