daily pastebin goal
11%
SHARE
TWEET

Untitled

a guest May 16th, 2018 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE R
  2. SET IsOrphaned = 1, DebugTimestampUtc = GETUTCDATE()
  3. FROM
  4.     RequestTable AS R
  5.     LEFT JOIN sys.sysprocesses AS P ON
  6.         P.spid = R.SPID
  7. WHERE P.spid IS NULL
  8.    
  9. INSERT INTO RequestTable(SPID, CreateTimestampUtc, ...)
  10. SELECT @@SPID, GETUTCDATE(), ...
  11. WAITFOR DELAY '00:00:30.000'
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
 
Top