Last post Apr 27, 2015 09:13 AM by Rajat
Apr 27, 2015 08:25 AM|rajemessage|LINK
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
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)
Apr 27, 2015 09:13 AM|Rajat|LINK
You don't need to put this as a parametrized value.
Just write below statement after begin statement of stored procedure
SET DEADLOCK PRIORITY NORMAL
For more detail check