How to close a cursor?

[MAK9974]

Hi guys.

is there anyway I can find a cursor that is open
so that i can close it?

I have a procedure running daily (across servers). that stopped suddenly with this error.

A cursor with the name 'xyz' already exists.

I tried closing and deallocating on destination server. I am getting the error like "cursor doesnot exist"

I need to run this procedure. i dont want to recycle the destination server.

any ideas?
-MAK

 

[dhoward007]

The cursor should be listed on the server you are running it on or the server you created it on.

you can find it using (select * from syscursors)

 

[MAK9974]

Nope.
I tried all these

select * from syscursors
select * from syscursortables
select * from syscursorrefs
select * from syscursorcolumns

no rows.

but when executing the proc i am getting same
cursor exist error.

 

[sunila7]

Hi,

Can u put the SP code, so that we can have a look at it.

Sunil

 

[MAK9974]

its actually sp created by replication.

All i can see is this error. and its in production