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 |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-05-28 : 13:49:36
|
| Hey there i am having problems getting the Stored Procedure for the Threaded Forum II ([url]http://www.sqlteam.com/item.asp?ItemID=1602[/url]) article to work in SQL Server 6.5.The problem is related to the Cursor Decleration. The "Local" keyword is not understood by SQL SErver 6.5 and if removed the following errors occur:sg 16915, Level 16, State 1A cursor with the name 'c1' already existsMsg 16905, Level 16, State 1The cursor is already openMsg 16915, Level 16, State 1A cursor with the name 'c1' already existsMsg 16905, Level 16, State 1The cursor is already openMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existMsg 16916, Level 16, State 1A cursor with the name 'c1' does not existi am hoping someone might know a way around this so this solution can be ported to SQL Server 6.5Thanks Christian-=:SpasmatiK:=-Edited by - Cyclonik on 05/28/2001 14:18:25Edited by - Cyclonik on 05/28/2001 14:18:48 |
|
|
|
|
|
|
|
Regarding Cursors and the THreaded Forum article