Create Trigger to log SQL that affected table?
I realise this issue has already been resolved but I was interested in how it could be resolved using SQL Server 2008 extended events. This is my first play with XEvents so I’m sure there’s lots to improve! Script to setup test Database CREATE TABLE [dbo].[TableWithMysteryUpdate]( [Period] [int] NOT NULL, [ColumnThatWillBeUpdated] [int] NOT NULL ) … Read more