Solved

Exist or not Exist

Posted on 2000-04-18
3
377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

737 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