Guest User

Untitled

a guest
Dec 7th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  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'
Add Comment
Please, Sign In to add comment