SQLSoldier May 27th, 2013 98 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- With TranIDs
- As (Select [Transaction ID]
- From fn_dblog(null, null)
- Where AllocUnitName = 'dbo.sysjobs.clust'
- Or AllocUnitName like 'dbo.sysschedules.%')
- Select SUSER_SNAME([Transaction SID]) As Changer, *
- From fn_dblog(null, null) DBL
- Inner Join TranIDs TI On TI.[Transaction ID] = DBL.[Transaction ID]
RAW Paste Data