daily pastebin goal
3%
SHARE
TWEET

Untitled

a guest Dec 7th, 2017 42 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT *
  2. FROM dbc.dbqlogtbl
  3. WHERE sessionid IN (
  4.         SELECT sessionId
  5.         FROM dbc.dbqlogtbl
  6.         WHERE statementtype = 'INSERT'
  7.             AND username = '<usrname>' /*username that executes the procedure if available*/
  8.             AND querytext LIKE '%yourdatabase.yourtable%'
  9.         )
  10.     AND statementtype = 'Call'
RAW Paste Data
Top