Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

  • RE: Help on deadlock issue in SQL Server 2005

    GilaMonster (3/16/2012)

    Might do.

    This is going to take a fair amount of analysis to work through. Will try to make time, but won't be today.

    Thank you Gail for your time. I...

    March 16, 2012 at 12:13 pm

    #1460678

  • RE: Help on deadlock issue in SQL Server 2005

    Do you think this cascading update/delete may have contributed to the deadlock issue?

    ALTER TABLE [dbo].[ScoreNote] WITH NOCHECK ADD CONSTRAINT [FK_ScoreNote_Score] FOREIGN KEY([ScoreID])

    REFERENCES [dbo].[Score] ([ScoreID])

    ON UPDATE CASCADE

    ON DELETE...

    March 15, 2012 at 8:24 pm

    #1460289

  • RE: Help on deadlock issue in SQL Server 2005

    GilaMonster (3/15/2012)

    The trigger and procedure code please?

    Does the java app use implicit transactions (will likely be a setting on the driver somewhere)?

    Gail,

    Here is the trigger code(mentioned in...

    March 15, 2012 at 3:09 pm

    #1460204

  • RE: Help on deadlock issue in SQL Server 2005

    GilaMonster (3/15/2012)

    Can you please post the definition of the ScoreNote and Score tables along with all indexes that they have. Also the definitions of the following procedures and triggers: ut_Score_Update_ScoreHistory,...

    March 15, 2012 at 12:07 pm

    #1460076

Viewing 4 posts - 1 through 5 (of 5 total)