SHARE
TWEET

Untitled

SQLSoldier May 27th, 2013 91 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. With TranIDs
  2. As (Select [Transaction ID]
  3.         From fn_dblog(null, null)
  4.         Where AllocUnitName = 'dbo.sysjobs.clust'
  5.         Or AllocUnitName like 'dbo.sysschedules.%')
  6. Select SUSER_SNAME([Transaction SID]) As Changer, *
  7. From fn_dblog(null, null) DBL
  8. Inner Join TranIDs TI On TI.[Transaction ID] = DBL.[Transaction ID]
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top