EXEC master.dbo.xp_readerrorlog 0, 1, N'deadlock victim=process', NULL, NULL, NULL, N'desc'

Both work in my environment you'd also have to change the Deadlock victim table fields to nvarchar as well not...

Carolyn Richardson (12/14/2016)

---

Do you get anything returned when you just query the log ie:-

EXEC master.dbo.xp_readerrorlog 0, 1, 'deadlock victim=process', NULL, NULL, NULL, N'desc'

obviously I'm not sure which log it...

mickegohle (12/14/2016)

---

Hiall,

Very nice with a Deadlock script. However, when I execute the scheduled job I didn't get any results even though I have a deadlock in the errorlog. I etried...

Hiall,

Very nice with a Deadlock script. However, when I execute the scheduled job I didn't get any results even though I have a deadlock in the errorlog. I etried to...

Sorry Guys, you have to be faster 😉

I think I found the answer myself here: https://msdn.microsoft.com/en-us/library/ms179331.aspx

Sorry for disturbing...

When I have created the temporal table the table "Orders" it's history-table is called "OrdersHistory".