a guest May 16th, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- UPDATE R
- SET IsOrphaned = 1, DebugTimestampUtc = GETUTCDATE()
- RequestTable AS R
- LEFT JOIN sys.sysprocesses AS P ON
- P.spid = R.SPID
- WHERE P.spid IS NULL
- INSERT INTO RequestTable(SPID, CreateTimestampUtc, ...)
- SELECT @@SPID, GETUTCDATE(), ...
- WAITFOR DELAY '00:00:30.000'
RAW Paste Data