I want to set deadlock priority of a stored proc to low so that when ever any one call it from entity or command object it should use same priority

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.

some body sugested to put 

set deadlockprioirty low 

go

exec yourSP()

but in this case i have to change my bussiness layer.

is there any other way from database which do the task?

yours sincerley.

April 27th, 2015 3:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics