Hello Jaydeep,

Its just a guess because I never done such a setup but maybe you could look at the:

Oracle Service for MTS

Is it installed and running?

Hope it can help,

Regards,

Carl

Hello Dale,

This is something that also happened to us: Having a simple "firehose" cursor involved in a deadlock (doing nothing else on the connection and not being in a transaction).

When it...

Thanks Noel,

you seem to confirm that there is no other way to check that.

Best regards,

Carl

Yep.

Hello Mike,

No doubt, this operation is automated.

Have a nice day.

Carl

Thank's Barsileus,

The concept of collation is not the problem here the problem is that since SQL Server 2000 was deliver it was written in BOL:

About Kana-sensitivenes:

"Specifies that SQL...

Hello Bersileus,

think it miss me something. There is something I don't understand.

How do you know which collation are "focussed" on kanatype sensitiveness?

I would have first tougth it is just related...

Hello Bersileus,

Thanks for that info.

I never tougth kantype sensitiveness would have something to do with this behavior.

Look at what it is said in BOL about that:

"Specifies that SQL...

Just to add a little more complexity, you can use Named Pipes but the underlying protocole stack is TCP/IP.

Carl

Hello Vanessa,

Look in BOL (books online) you'll see many topics about that subject. It depends on how deep you want to go but if you search for these keywords in BOL you...

In fact, this is my error.

I was using object_name(rsc_objid) not being in the rigth DB .

Forget all that.

Best regards

Carl

Hello Mike,

I will try it but knowing that sp_lock add taken its information from syslockinfo and used the rsc_objid to output the object Name and giving me sp_recompile, I am...

... In fact not completely.

There is a last thing I would found very usefull to learn:

How to distinguish which protocol stack is used underneath (TCP/IP, NetBeui or NwLink) when the Named Pipes...

Hello Allen,

found the article id: 101150 more interesting...

http://support.microsoft.com/default.aspx?scid=kb;en-us;101150

It goes deeper and help me understand my case completely.

Best regards,

Carl

Hello Allen,

First of all, let me say that the problem is not happening here at our site, it is one of our client that have this problem.

Here is the error received...