I want to see the historical data and who has changed the data.

Hi GilaMaster,

Thanks for the help.

Can you please let me know what is the exact problem.

Which statement deadlock is being created on? (Select or Update)

and which table is causing deadlock?

Thanks &...

there is no Primary Key, No Index on any table

Hi,

Please Find the Needed Info :

CREATE PROCEDURE [dbo].[UpdateMailMergeStatus]

AS

BEGIN

Update MailMergeFile set MailMergeFile.Status=4,StatusUpdatedOn=CURRENT_TIMESTAMP

where MailMergeFile.Status=3

And

0=(select COUNT(*) from MailMergeWorkItem

where MailMergeWorkItem.MailMergeID=MailMergeFile.MailMergeID

and MailMergeWorkItem.Status!=3);

update MailMerge set IsMailMerged='True', MergeStatusID=2, CompletedDate=CURRENT_TIMESTAMP

where MailMerge.IsMailMerged='False'

and 0 =...