In the profile, searc for text <deadlock-List>. In the row, rt click -->Extract Event Data> and save the file. Attach the file here.

cheers

Siddarth

If possible pls send the dead lock graph. I am currently troubleshooting the same. There are few important this which are not so easy to know. I will be able...

Also union can be used

Select UserName from table B

Union

Select somecolumn as UserName from table B

we use "some-sa" account for logging on to db server in connection string in asp.net web application.

cheers

Suppose you have an db account with name 'ta' and pwd as 'ty'. When a user connects to DB through Asp.net, he useses the same account details in connection details...

Its sorted by changing data base owner. when data base x was restored from live to test, both env had different data base ids. we changed the owner and it...

The issue came because the data base id on live and test environment were different. We have correct the data base id and its sorted now. also the data base...

thanks alot for the info. We tried and unfortunately that didint worked for us. We are trying the whole process again.

cheers

Siddarth

thanks alot for the info.

cheers

Siddarth

No we dont have triggers. The reason why I asked last question is, in dead lock graph,

SPID=73 has IX lock on AccessRequestStatus which is a view and SPID74 is...

Hi

I have a table with as follows:-

CREATE TABLE [dbo].[RqstStats](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[RequestID] [bigint] NOT NULL,

[StatusID] [int] NOT NULL,

[CreatedBy] [int] NULL,

[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_RqstStats_CreatedDate] DEFAULT (getdate()),

[ApproverID] [int]...

Hi

I have a table with as follows:-

CREATE TABLE [dbo].[RqstStats](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[RequestID] [bigint] NOT NULL,

[StatusID] [int] NOT NULL,

[CreatedBy] [int] NULL,

[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_RqstStats_CreatedDate] DEFAULT (getdate()),

[ApproverID] [int]...

Seems some issue with the posting, I am attaching the file in txt format.

Could you please arrange to answer the followingt things in respect to the dead lock graph posted:-

1:There are 4 process involved but the no of process nodes appearing is 6....

SELECT @deleteRequestID = Request.ID FROM dbo.Request

INNER JOIN dbo.RequestStatus ON Request.CurrentRequestStatusID = RequestStatus.ID

AND RequestStatus.StatusID NOT...