SQLSoldier Apr 7th, 2014 89 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 [Transaction Name] = 'Alter Authorization')
  5. Select F.*
  6. From fn_dblog(null, null) F
  7. Inner join TranIDs T On F.[Transaction ID] = T.[Transaction ID]
  8. Where F.[Lock Information] Like '%DB_PRINCIPAL_SID($hash%'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand