Solved

Exist or not Exist

Posted on 2000-04-18
3
371 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now