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.
9 freelanceria on tarjonnut keskimäärin 167 $ tähän työhön
Hi, I have 5 years of experience in developing SQL stored procedure..I can finish this job perfectly on time.. Give me a chance to prove myself...Thanks
Hi This is Sajid Wasim, Dhaka, Bangladesh. I am interested in this project. I have 13 years of experience in SQL Server and currently working in Bank as a Senior System Analyst.