Hello All.......I am new in Asp.Net Web development..........I want to generate database change notification using SignalR, for this, I am using SQL Server 2008 R2.
I am getting failure with following command
ALTER DATABASE SignalRDummy SET ENABLE_BROKER.
It says
"Msg 1205, Level 13, State 68, Line 1Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.Msg 5069, Level 16, State 1, Line 1ALTER DATABASE statement failed."
I have tried
SET DEADLOCK_PRIORITY LOW;
It doesnt work.
Thanks in advance.Regards.