Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM dbc.dbqlogtbl
- WHERE sessionid IN (
- SELECT sessionId
- FROM dbc.dbqlogtbl
- WHERE statementtype = 'INSERT'
- AND username = '<usrname>' /*username that executes the procedure if available*/
- AND querytext LIKE '%yourdatabase.yourtable%'
- )
- AND statementtype = 'Call'
Add Comment
Please, Sign In to add comment