I need a stored proceedure which I can execute from my [url removed, login to view] Client Server Application which will get the current Session ID and give me the last 5 Minutes of TSQL Statements which have been run.
SQL Profiler can perform this in a Post analysis function however this is to problem solve a app issue while in production which makes it impossible to start the profiler at the approriate time.
The SQL Server is also SQL Server Express 2008.
I would prefer to not have to switch this on and off however I'm not sure if it is possible to achieve without constantly running some sort of audit which will impact performance.
Note: I am not interested in simply returning the current running SQL, but in the SQL which ran a couple of minutes ago.
2 freelanceria on tarjonnut keskimäärin 75 $ tähän työhön
Hi,I am ram from digital dreams technology. I have worked on complex queries and PL/SQL on SQL Server. Please check message box for more details.