Solved

Exist or not Exist

Posted on 2000-04-18
3
376 Views
Last Modified: 2006-11-17
Procedure creates cursor and failed before deallocate it. Next run give me this interesting analisys:

Server: Msg 16915, Level 16, State 1, Line 0
A cursor with the name 'tmp_murekkep_cur' already exists.
Server: Msg 16916, Level 16, State 1, Procedure _sp_customer_pool_murekkep_bul, Line 21
A cursor with the name 'tmp_murrekep_cur' does not exist.

question here:
are cursor exist or it not exist?

:)
0
Comment
Question by:ATM
3 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 2729594
ATM,

"To be or not to be that's the question!"

Shakespeare did already specified the question/answer for you !
0
 
LVL 7

Accepted Solution

by:
simonsabin earned 1 total points
ID: 2729751
You have two different cusrors here the first is called  
'tmp_murekkep_cur' and the second
'tmp_murrekep_cur'

That is your problem
0
 
LVL 1

Author Comment

by:ATM
ID: 2729784
hmm...
simonsabin really ... you right ... i have spend about 5*10 mins to find the that difference ... :(
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question