CZ:
Jak mám nastavit profiler, aby se v něm zobrazovali události StartTransaction, Commit a Rollback volané z SDAC TMSConnection?
Příkazy ne jsou standardně vidět jako TSQL.
Děkuji za odpověď.
EN:
How do I set the MSSQL profiler to it depicted events StartTransaction, Commit and Rollback called from SDAC TMSConnection?
Commands are not normally seen as TSQL.
Thank you for your reply.
Log profiler:
Audit Login -- network protocol: LPC
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.020
SQL:BatchStarting SET LOCK_TIMEOUT 2000 Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.020
SQL:BatchCompleted SET LOCK_TIMEOUT 2000 Project1.exe jan.javurek QGIRIT\jan.javurek 0 0 0 0 6400 56 2010-04-23 17:45:34.020 2010-04-23 17:45:34.020
SQL:BatchStarting SET NO_BROWSETABLE ON Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.023
SQL:BatchCompleted SET NO_BROWSETABLE ON Project1.exe jan.javurek QGIRIT\jan.javurek 0 0 0 0 6400 56 2010-04-23 17:45:34.023 2010-04-23 17:45:34.023
SQL:BatchStarting SELECT * FROM StoreCards Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.023
SQL:BatchCompleted SELECT * FROM StoreCards Project1.exe jan.javurek QGIRIT\jan.javurek 0 7 0 9 6400 56 2010-04-23 17:45:34.023 2010-04-23 17:45:34.030
SQL:BatchStarting SELECT * FROM Firms Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.037
SQL:BatchCompleted SELECT * FROM Firms Project1.exe jan.javurek QGIRIT\jan.javurek 0 28 0 26 6400 56 2010-04-23 17:45:34.037 2010-04-23 17:45:34.063
Audit Logout Project1.exe jan.javurek QGIRIT\jan.javurek 0 35 0 50 6400 56 2010-04-23 17:45:34.020 2010-04-23 17:45:34.070
Trace Stop 2010-04-23 17:45:41.957
Delphi code:
var
MSConnection: TMSConnection;
Query: TMSQuery;
begin
MSConnection:= TMSConnection.Create(nil);
Query := TMSQuery.Create(nil);
try
MSConnection.Database := EdDatabase.Text;
MSConnection.Authentication := auWindows;
MSConnection.Server := EdServer.Text;
MSConnection.Connect;
Query.Connection := MSConnection;
Query.SQL.Text := 'SELECT * FROM StoreCards';
Query.Execute;
MSConnection.StartTransaction;
try
Query.SQL.Text := 'SELECT * FROM Firms';
Query.Execute;
MSConnection.Commit;
except
MSConnection.Rollback;
end;
finally
Query.Close;
Query.Free;
MSConnection.Disconnect;
MSConnection.Free;
end;
end;
StartTransaction, Commit and Rollback on SQL Server Profiler
-
- Posts: 20
- Joined: Fri 29 Jan 2010 10:05
- Contact:
Re: StartTransaction, Commit and Rollback on SQL Server Profiler
Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.020
SQL:BatchStarting SET LOCK_TIMEOUT 2000 Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.020
_________________________
https://casinomagzine.com/one-piece-filler-list/
Casino Calzone Bonus and Promotions
solarmovies
https://recipesny.com/
SQL:BatchStarting SET LOCK_TIMEOUT 2000 Project1.exe jan.javurek QGIRIT\jan.javurek 6400 56 2010-04-23 17:45:34.020
_________________________
https://casinomagzine.com/one-piece-filler-list/
Casino Calzone Bonus and Promotions
solarmovies
https://recipesny.com/
Last edited by waleeed1 on Sat 03 Apr 2021 07:55, edited 2 times in total.
Re: StartTransaction, Commit and Rollback on SQL Server Profiler
Please clarify the issue. If you have a simple test sample reproducing the problem, please send it to us.
Re: StartTransaction, Commit and Rollback on SQL Server Profiler
Please clarify the issue. If you have a simple test sample reproducing the problem, please send it to us.
Re: StartTransaction, Commit and Rollback on SQL Server Profiler
Please clarify the issue. If you have a simple test sample reproducing the problem, please send it to us.