Solved

Exist or not Exist

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Select - find rows created in last 6 months 4 38
T-SQL: "HAVING CASE" Clause 1 27
VB.net and sql server 4 36
Tsql query 6 22
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.

821 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