Thank you so much for the reply Bill

but can you please explain me what does this message means?

Transaction (Process ID 51) was deadlocked on lock | comunication buffer resorces with...

Please help me

I am not deleting large number of rows. This SP deletes only 59 rows.

I am seeing this in profiler

Parallel qury worker thread was involvd in a...

Thanks for the reply, no I am not deleting large number of rows. This SP deletes only 59 rows.

I am seeing this in profiler

Parallel qury worker thread was involvd in...

Please help me

[/quote]

I like to keep a log table available that I can insert records like "starting at..." plus date and time and "finished at..." plus date and time. Make sure these...

GilaMonster (2/12/2015)

---

yes, that's...

ChrisM@Work (2/12/2015)

---

The stored procedure is written in a procedural Row-By-Agonizing_Row way indicating an inexperienced programmer. The upside is that you have plenty of scope for improvement by a professional. So...

Thanks for your reply.

Sorry Gila , you are absolutely correct people answering questions here are doing so in their spare time and are not paid for the work.

I was...

I am not sure how can I check this in SQL Server ?? Is there any option / setting in SQL to enable or disable that??

If yes then please share...

Please please reply me its urgent is there any sql server side setting whom can enable this???

sp_rest_connection???

as only this customers trace file is showing such behavior..

Thanks for the quick response!!!

What's surprising is that only this customer's trace file who is using our application is showing

exec sp_reset_connection

Our application is build up of .net using linq...

Thanks for your reply but the main concern is that is there any performance impact?? if I use your trigger or mine?

Thank you soo much!!!! I am now doing the following right after defining the CTE

SELECT *

INTO #CostCenterList

FROM CostCenterList

And then referenceing #CostCenterList in the subsequent code.

Thanks once again for quick...

Thanks for the reply 🙂

THANKS for the reply.

So, what is the solution of this problem?

any help will be highly appreciated.