Đã Hủy

TSQL Command History

I need a stored proceedure which I can execute from my VB.NET 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.

Kỹ năng: SQL

Xem thêm: sql server command history, problem statements, tsql history sql statements, tsql command history, sql server 2008, TSQL, sql audit history, app session, sql stored function, post execute, session app running, production app, app analysis, sql express 2012 command, sql server command, audit sql, sort problem, audit application, express 2008, performance problem, impossible app, client sql server, sql analysis, jeremybentvelzen, sql 2008 command

Về Bên Thuê:
( 3 nhận xét ) Castle Hill, Australia

Mã Dự Án: #1709440

9 freelancer đang chào giá trung bình $167 cho công việc này

digidreamstech

I have worked on complex queries and PL/SQL on SQL Server. Please check message box for more details.

$200 AUD trong 5 ngày
(3 Đánh Giá)
3.9
PauloSam

Hello Sir I`m ready and thanks

$250 AUD trong 5 ngày
(2 Đánh Giá)
3.2
amfuries

################### ******************* WE HAVE DONE THE SAME APPLICATION PLEASE CHECK THE PM **************** #############

$200 AUD trong 5 ngày
(4 Đánh Giá)
2.8
Dusan74

I have read at your project demands and in my opinion there is two solutions: using SQL Dynamic Management Views and Functions or using tracing. I think using tracing (its job is to capture SQL Server-related communica Thêm

$150 AUD trong 2 ngày
(4 Đánh Giá)
2.5
Drohilla

Hi i have 6 Years of Experience in SQL Development and having strong command over T-SQL. Looking forward to take this project.

$75 AUD trong 1 ngày
(0 Đánh Giá)
0.0
GANESAPERUMAL

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

$50 AUD trong 1 ngày
(0 Đánh Giá)
0.0
assuranceES

Hello We can do this project Thanks K

$500 AUD trong 4 ngày
(0 Đánh Giá)
0.0
sajidwasim

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.

$200 AUD trong 3 ngày
(0 Đánh Giá)
0.0
husainmodi

Hi, i am certified oracle associate, working in MNC from last two years as Oracle database [url removed, login to view] good hands on experience in shifting or upgrading of [url removed, login to view] i have made Procedure and functions as per o Thêm

$30 AUD trong 7 ngày
(0 Đánh Giá)
0.0
jonyrhsoft

Hello Sir, I have already create the query Please check PM

$50 AUD trong 1 ngày
(1 Đánh Giá)
0.0