SQL Server provides a number of cursor-related stored procedures with which you should familiarize yourself if you expect to work with cursors much. Table 14.3 provides a brief list of them, along with a description of each.
Each of these returns its result via a cursor output parameter, so you'll need to supply a local cursor variable in order to process them.
|sp_cursor_list||Returns a list of the cursors and their attributes that have been opened by a connection|
|sp_describe_cursor||Lists the attributes of an individual cursor|
|sp_describe_cursor_columns||Lists the columns (and their attributes) returned by a cursor|
|sp_describe_cursor_tables||Returns a list of the ...|