locked
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. RRS feed

  • Question

  • User2102072086 posted

    Hi,

    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.

    (i want to do it only for this stored procedure)

    some body sugested to put 

    set deadlockprioirty low 

    go

    exec yourSP()

    Please tel me  where and how it can be set in data access layer.( that is in c# code form entitiy and people who are using command object) 

    yours sincerley.

    Monday, April 27, 2015 8:25 AM

Answers