Page:1/3
10/3/2005 3:54:16 PM
Database Table Drops
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
Table Dropped
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Dropped
sa
192.168.1.5
54249
192.168.1.100
1433
8/21/2005 12:09:45 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54250
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54251
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54252
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54253
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54254
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54255
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54257
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54258
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
54259
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.5
48971
192.168.1.100
1433
8/23/2005 11:29:25 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49016
192.168.1.100
1433
8/23/2005 11:35:33 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49018
192.168.1.100
1433
8/23/2005 11:35:36 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49019
192.168.1.100
1433
8/23/2005 11:35:40 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49084
192.168.1.100
1433
8/23/2005 11:45:22 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49090
192.168.1.100
1433
8/23/2005 11:46:11 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49112
192.168.1.100
1433
8/23/2005 11:49:06 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49118
192.168.1.100
1433
8/23/2005 11:49:50 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
49122
192.168.1.100
1433
8/23/2005 11:50:17 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
54161
192.168.1.100
1433
8/24/2005 12:33:18 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
54168
192.168.1.100
1433
8/24/2005 12:34:23 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.5
54177
192.168.1.100
1433
8/24/2005 12:35:10 PM
SQL Query Text:
DROP TABLE foo
Page:2/3
10/3/2005 3:54:16 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Dropped
sa
192.168.1.5
54283
192.168.1.100
1433
8/24/2005 12:51:11 PM
SQL Query Text:
DROP TABLE foo
Table Dropped
sa
192.168.1.7
57469
192.168.1.100
1433
9/14/2005 12:23:28 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57472
192.168.1.100
1433
9/14/2005 12:23:39 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57474
192.168.1.100
1433
9/14/2005 12:23:49 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57476
192.168.1.100
1433
9/14/2005 12:23:51 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57477
192.168.1.100
1433
9/14/2005 12:23:52 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57478
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57479
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57480
192.168.1.100
1433
9/14/2005 12:23:54 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57481
192.168.1.100
1433
9/14/2005 12:23:55 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57482
192.168.1.100
1433
9/14/2005 12:23:55 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57483
192.168.1.100
1433
9/14/2005 12:23:56 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57484
192.168.1.100
1433
9/14/2005 12:23:57 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57485
192.168.1.100
1433
9/14/2005 12:23:57 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57486
192.168.1.100
1433
9/14/2005 12:23:58 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57487
192.168.1.100
1433
9/14/2005 12:23:58 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57488
192.168.1.100
1433
9/14/2005 12:23:59 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57489
192.168.1.100
1433
9/14/2005 12:24:00 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57491
192.168.1.100
1433
9/14/2005 12:24:00 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57492
192.168.1.100
1433
9/14/2005 12:24:01 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57493
192.168.1.100
1433
9/14/2005 12:24:02 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57494
192.168.1.100
1433
9/14/2005 12:24:02 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57496
192.168.1.100
1433
9/14/2005 12:24:03 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57497
192.168.1.100
1433
9/14/2005 12:24:03 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57498
192.168.1.100
1433
9/14/2005 12:24:04 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57499
192.168.1.100
1433
9/14/2005 12:24:04 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57500
192.168.1.100
1433
9/14/2005 12:24:05 PM
SQL Query Text:
DROP TABLE test1
Page:3/3
10/3/2005 3:54:16 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Dropped
sa
192.168.1.7
57501
192.168.1.100
1433
9/14/2005 12:24:06 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57502
192.168.1.100
1433
9/14/2005 12:24:08 PM
SQL Query Text:
DROP TABLE test1
Table Dropped
sa
192.168.1.7
57504
192.168.1.100
1433
9/14/2005 12:24:15 PM
SQL Query Text:
DROP TABLE test1
