See if you can connect to the server through Remote Desktop, you can access all the tools.

What version of SQL server is installed on the server? and What is installed...

Gila, I attached the table and index definitions. Do you need anything else?

The deadlocking statements are:

==[shared Application.PK]==[needs Shared Resource.PK]==

-- SPID:64; OriginalSP: ApplicationApplicationGetObject CurrentSP: ProcApplicationApplicationGet Line# 77 SELECT

SELECT ...

They are all tables with around 30-50 columns. I just tried the create to copy the script but its big.

ALTER TABLE [dbo].[A] ADD CONSTRAINT [PK_A] PRIMARY KEY CLUSTERED

(

[ID]...

Silverfox (9/17/2009)

😉

Thanks. Nice info.