Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A cursor already exists
Message
 
To
05/03/2008 09:30:04
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01298878
Message ID:
01299057
Views:
17
>I have this script that I run on a regular basis. I have a DECLARE tableIndexes CURSOR FOR that is inserted at several places in the script. But, if the script didn't run well on the last time, when I run the script again, I might have this error:
>
>"A cursor with the name 'tableIndexes' already exists."
>
>How can I make sure all cursor are cleaned before I start running the script.

Why you need CURSOR?
In 90% of time there is no need of it.
Sorry if I asked a question already answered, but I didn't follow the whole thread so far, I just stared.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform