May 4, 2005 at 12:05 pm
Is there a stored procedure, a utility, or a command that will allow me to examine the structure of a cursor similar to the SP_Columns procedure? I want to be able to see how the cursor columns are defined after I run a query to select data into a cursor.
Jim White
May 4, 2005 at 12:09 pm
Select * from master.dbo.syscursorcolumns
May 5, 2005 at 6:06 am
I tried doing the select you recommended but I got the following error message back in Query Analyzer:
SELECT permission denied on object 'syscursorcolumns', database 'master', owner 'dbo'.
Do I have to go to my DBA and get him to allow me permission to do this or what?
Jim
May 5, 2005 at 7:00 am
Most likely explanation...
May 5, 2005 at 11:03 am
sp_describe_cursor_columns
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply