arida
asked on
The "@@Cursor_Rows" is getting me "-1"????
When I use the @@CURSOR_ROWS global variable in SQL Server, it is getting me -1 as an answer, although I know that the cursor returns more than 1 row.
I tried to change the setup configuration in sp_configure, but it did not work.
Is there a setup variable that I must know about so that it works properly?
Thanks
I tried to change the setup configuration in sp_configure, but it did not work.
Is there a setup variable that I must know about so that it works properly?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ispaleny
Open your cursor as static. Now it can accumulate changes from other users, so it cannot return an accurate rowcount.
arida:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
No comment has been added to this question in more than 268 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: xenon_je http:#8193611
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
monosodiumg
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Accept: xenon_je http:#8193611
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
monosodiumg
EE Cleanup Volunteer