Here is the command in the view.

SELECT ...

I found it through Activity Monitor.

And i should add that "WITH (NOLOCK)" is also present in the view "vWorkflowTransition" which is the first query.

No Foreign keys, completely independent tables.

sorry i should have said,...

becuase it is embeded in a third party dll, which i can not modify.

I should add that you can try re-installing IIS too if you donot have any other application deployed to it.

Try to reconfigure the reporting services, if this does not help then try to re-install reporting services.

I am sorry i cannot suggest a better solution.

What error are you getting?can someone else connect to these?

Make sure services are running.

Try deleting the existing report and shared data sources (if you have any) and then deploy the report again.

there are two things that you can try at the client level, first is "Connection Timeout=n" property of the connection string in the client application, second is "CommandTimeout=n" property of...

Thanks Gail, will give it a shot.

This is a third party CRM application that we are using, i understand that there is no need of coalesce function but the delete query is coming from a dll...

Thanks Gail i appreciate your suggestions.

Here is the script for the problematic table, 2 indexes on the table, and 2 queries that are coming for this table, and these queries...

The only concern i have is, its a very critical production db and i am...

GilaMonster (4/24/2009)

---

Have you considered snapshot isolation? It'll hit TempDB hard if you have that much activity, but you'll have no blocking. It may be worth testing out on a test...