Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 CURSOR error.

Author  Topic 

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-06-21 : 23:32:57
Thanks for reading this post, can someone help me in helping what would be the cause of this error

'Msg 16915, Level 16, State 1, Line 513
A cursor with the name 'cur_distSummary' already exists.
Msg 16905, Level 16, State 1, Line 517
The cursor is already open.
Msg 16943, Level 16, State 4, Line 518
Could not complete cursor operation because the table schema changed after the cursor was declared.'

Thanks

AB

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-21 : 23:37:19
its obvious. check if you've explicitly closed the cursor

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-06-22 : 08:40:10
Also what are youdoing with the cursor?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-06-24 : 19:43:09
Hi All,

Can anyone tell me if I replace a cursor to another loop like (while exists select id from table), would this immensely improve performance.

Thanks,

AB
Go to Top of Page

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-06-29 : 09:32:24
quote:
Originally posted by benildusmuerling

Hi All,

Can anyone tell me if I replace a cursor to another loop like (while exists select id from table), would this immensely improve performance.

Thanks,

AB



Performance wise: Cursors are most likely to be avoided unless needed. Also, in SQL cursors has status to check if there's more data to pass to be treated inside the while loop.

Try to take out not needed statements to improve the performance, and look at your execution plans.
luck,

--------------------------
Get rich or die trying
--------------------------
Go to Top of Page

DKnight
Starting Member

1 Post

Posted - 2012-11-28 : 13:25:51
Don't forget that in addition to closing the cursor you need to DEALLOCATE the cursor.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-02 : 02:39:43
quote:
Originally posted by benildusmuerling

Hi All,

Can anyone tell me if I replace a cursor to another loop like (while exists select id from table), would this immensely improve performance.

Thanks,

AB


One thing to consider is why do you need to go for row by row processing and why cant you implement it in set based manner?
Set based solution would be in most cases the fastest solution to implement

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Howard43Willard
Starting Member

8 Posts

Posted - 2012-12-02 : 20:21:46
Could not complete cursor operation because the table schema changed after the cursor was declared.





Go to Top of Page
   

- Advertisement -