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.
| Author |
Topic |
|
kam
Starting Member
17 Posts |
 Posted - 2006-03-28 : 16:48:03
|
| Hi, I am calling a procedure (which contains a cursor) a number of times from another procedure (passing through different arguments). It seems that if i run the procedure with the cursors more than once I get an error:Server: Msg 16915, Level 16, State 1, Procedure compareSubscriptionCategories, Line 16A cursor with the name 'subCursor' already exists.Server: Msg 16915, Level 16, State 1, Procedure compareSubscriptionCategories, Line 22A cursor with the name 'jobCursor' already exists.I've made sure that I used the CLOSE statement in the procedure to close the cursor, but it does'nt suffice.Can anyone provide any suggestions?Many Thanks. |
|
|
kam
Starting Member
17 Posts |
Posted - 2006-03-28 : 16:52:51
|
| I got it working :)There is a deallocate command which I was'nt aware of. :S |
 |
|
|
|
|
|
de-allocating cursors from memory