Home Forums SQL Server 2008 SQL Server 2008 - General I want to set deadlock priority of a stored proc to low so that when ever any one calls it from entity or command object it should use same priority. RE: I want to set deadlock priority of a stored proc to low so that when ever any one calls it from entity or command object it should use same priority.

  • April 27, 2015 at 1:59 am

    #1793583

    Maybe I'm missing something, but you can set the deadlock priority in the procedure's code.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/