Page:1/6
10/3/2005 3:54:30 PM
Database transaction failures
Description
Allows auditing on all database administration, management, security and maintenance operations
For more information on database auditing, go to :
http://www.microsoft.com/technet/support/eventserrors.mspx
Parameters
Audit Type
Failed Transactions
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Failed Transactions
sa
192.168.1.7
8176
192.168.1.5
6868
8/21/2005 11:47:46 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8176
192.168.1.5
6868
8/21/2005 11:47:46 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8203
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8203
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8204
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8204
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8205
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8205
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8206
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8206
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8207
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8207
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8209
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8209
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8210
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8210
192.168.1.5
6868
8/21/2005 11:49:58 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8211
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8211
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8212
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8212
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
/* an error request */ select name from badtablename
Failed Transactions
sa
192.168.1.7
8213
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
8213
192.168.1.5
6868
8/21/2005 11:49:59 AM
SQL Query Text:
/* an error request */ select name from badtablename
Page:2/6
10/3/2005 3:54:30 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Failed Transactions
sa
192.168.1.5
54194
192.168.1.100
1433
8/21/2005 12:07:12 PM
SQL Query Text:
Logout:sa@roman:54194
Failed Transactions
sa
192.168.1.5
54240
192.168.1.100
1433
8/21/2005 12:09:01 PM
SQL Query Text:
Logout:sa@roman:54240
Failed Transactions
sa
192.168.1.5
54249
192.168.1.100
1433
8/21/2005 12:09:45 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54249
192.168.1.100
1433
8/21/2005 12:09:45 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54249
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54250
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54250
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54250
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54251
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54251
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54251
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54252
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54252
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54252
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54253
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54253
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54253
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54254
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54254
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54254
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54255
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54255
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54255
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54257
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54257
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54257
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54258
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
SELECT * FROM Employees
Page:3/6
10/3/2005 3:54:30 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Failed Transactions
sa
192.168.1.5
54258
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54258
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.5
54259
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
SELECT * FROM Employees
Failed Transactions
sa
192.168.1.5
54259
192.168.1.100
1433
8/21/2005 12:09:49 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.5
54259
192.168.1.100
1433
8/21/2005 12:09:49 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
mel
192.168.1.7
13939
192.168.1.5
6868
8/21/2005 9:17:38 PM
SQL Query Text:
exec getdate()
Failed Transactions
mel
192.168.1.7
13949
192.168.1.5
6868
8/21/2005 9:18:39 PM
SQL Query Text:
exec getdate()
Failed Transactions
mel
192.168.1.7
13953
192.168.1.5
6868
8/21/2005 9:19:03 PM
SQL Query Text:
exec getdate()
Failed Transactions
mel
192.168.1.7
13958
192.168.1.5
6868
8/21/2005 9:19:33 PM
SQL Query Text:
exec getdate()
Failed Transactions
sa
192.168.1.7
57469
192.168.1.100
1433
9/14/2005 12:23:28 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57469
192.168.1.100
1433
9/14/2005 12:23:28 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57469
192.168.1.100
1433
9/14/2005 12:23:28 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.7
57472
192.168.1.100
1433
9/14/2005 12:23:40 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57472
192.168.1.100
1433
9/14/2005 12:23:40 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57472
192.168.1.100
1433
9/14/2005 12:23:40 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.7
57474
192.168.1.100
1433
9/14/2005 12:23:50 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57474
192.168.1.100
1433
9/14/2005 12:23:50 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57474
192.168.1.100
1433
9/14/2005 12:23:50 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.7
57476
192.168.1.100
1433
9/14/2005 12:23:51 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57476
192.168.1.100
1433
9/14/2005 12:23:51 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57476
192.168.1.100
1433
9/14/2005 12:23:51 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.7
57477
192.168.1.100
1433
9/14/2005 12:23:52 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57477
192.168.1.100
1433
9/14/2005 12:23:52 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57477
192.168.1.100
1433
9/14/2005 12:23:52 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Failed Transactions
sa
192.168.1.7
57478
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
INSERT INTO Orders VALUES('ShweWin', 4, '7/4/1996','7/4/1996','7/4/1996',8,12,'new ship','new ship address','paris','paris','3444-44','France')
Failed Transactions
sa
192.168.1.7
57478
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
SELECT top * FROM Orders WHERE OrderId > 10248
Failed Transactions
sa
192.168.1.7
57478
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
DELETE FROM Orders WHERE OrderId IN ( '11072', '11076')
Page:4/6
10/3/2005 3:54:30 PM