declare @P1 int set @P1=180150000
declare @P2 int set @P2=1
declare @P3 int set @P3=16388
declare @P4 int set @P4=4

exec sp_cursoropen
@P1 output,
N'Select * from MyTable
Where LoggedOn = ''Y''' ,
@P2 output,
@P3 output,
@P4 output

select
@P1 as 'Cursor',
@P2 as 'ScrollOption',
@P3 as 'ConcurrencyOption',
@P4 as 'RowCount'


- What happens when exec sp_cursoropen gets run consecutively & numerously (with the same command)?

- Does exec sp_cursoropen have to have a corresponding "sp_cursorclose" ?

-Anybody experience with these system procedures? thanks