Page:1/3
10/3/2005 3:53:57 PM
Database Table Creations
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 Created
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Created
sa
192.168.1.7
8198
192.168.1.5
6868
8/21/2005 11:49:30 AM
SQL Query Text:
create table test_table(one char(10), two char(10))
Table Created
sa
192.168.1.5
54249
192.168.1.100
1433
8/21/2005 12:09:45 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54250
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54251
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54252
192.168.1.100
1433
8/21/2005 12:09:46 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54253
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54254
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54255
192.168.1.100
1433
8/21/2005 12:09:47 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54257
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54258
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.5
54259
192.168.1.100
1433
8/21/2005 12:09:48 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
mel
192.168.1.7
15025
192.168.1.5
6868
8/21/2005 9:26:42 PM
SQL Query Text:
create table suspicious_table (a int)
Table Created
sa
192.168.1.5
48971
192.168.1.100
1433
8/23/2005 11:29:25 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
48977
192.168.1.100
1433
8/23/2005 11:30:11 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49009
192.168.1.100
1433
8/23/2005 11:34:45 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49016
192.168.1.100
1433
8/23/2005 11:35:33 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49018
192.168.1.100
1433
8/23/2005 11:35:36 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49019
192.168.1.100
1433
8/23/2005 11:35:40 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49084
192.168.1.100
1433
8/23/2005 11:45:22 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49090
192.168.1.100
1433
8/23/2005 11:46:11 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49112
192.168.1.100
1433
8/23/2005 11:49:06 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
49118
192.168.1.100
1433
8/23/2005 11:49:50 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Page:2/3
10/3/2005 3:53:57 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Created
sa
192.168.1.5
49122
192.168.1.100
1433
8/23/2005 11:50:17 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
54161
192.168.1.100
1433
8/24/2005 12:33:18 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
54161
192.168.1.100
1433
8/24/2005 12:33:18 PM
SQL Query Text:
create table event (, alert_time datetime default '12/31/1969 19:00:00',, alert_level int not null,, alert_reason varchar(50) not null, , alert_value varchar(50) not null,, alert_text varchar(50) not null,, agent_id varchcar(15) not null,,
Table Created
sa
192.168.1.5
54168
192.168.1.100
1433
8/24/2005 12:34:23 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
54168
192.168.1.100
1433
8/24/2005 12:34:23 PM
SQL Query Text:
create table event (, alert_time datetime default '12/31/1969 19:00:00',, alert_level int not null,, alert_reason varchar(50) not null, , alert_value varchar(50) not null,, alert_text varchar(50) not null,, agent_id varchar(15) not null,,
Table Created
sa
192.168.1.5
54177
192.168.1.100
1433
8/24/2005 12:35:10 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
54177
192.168.1.100
1433
8/24/2005 12:35:10 PM
SQL Query Text:
create table event (, alert_time datetime default '12/31/1969 19:00:00',, alert_level int not null,, alert_reason varchar(50) not null, , alert_value varchar(50) not null,, alert_text varchar(50) not null,, agent_id varchar(15) not null,,
Table Created
sa
192.168.1.5
54283
192.168.1.100
1433
8/24/2005 12:51:11 PM
SQL Query Text:
CREATE TABLE foo (id INTEGER, name VARCHAR(20))
Table Created
sa
192.168.1.5
54283
192.168.1.100
1433
8/24/2005 12:51:11 PM
SQL Query Text:
create table event (, alert_time datetime default '12/31/1969 19:00:00' not null,, alert_level int not null,, alert_reason varchar(50) not null, , alert_value varchar(50) not null,, alert_text varchar(50) not null,, agent_id varchar(15) not
Table Created
sa
192.168.1.7
57469
192.168.1.100
1433
9/14/2005 12:23:28 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57472
192.168.1.100
1433
9/14/2005 12:23:39 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57474
192.168.1.100
1433
9/14/2005 12:23:49 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57476
192.168.1.100
1433
9/14/2005 12:23:51 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57477
192.168.1.100
1433
9/14/2005 12:23:52 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57478
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57479
192.168.1.100
1433
9/14/2005 12:23:53 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57480
192.168.1.100
1433
9/14/2005 12:23:54 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57481
192.168.1.100
1433
9/14/2005 12:23:55 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57482
192.168.1.100
1433
9/14/2005 12:23:55 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57483
192.168.1.100
1433
9/14/2005 12:23:56 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57484
192.168.1.100
1433
9/14/2005 12:23:57 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57485
192.168.1.100
1433
9/14/2005 12:23:57 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57486
192.168.1.100
1433
9/14/2005 12:23:58 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57487
192.168.1.100
1433
9/14/2005 12:23:58 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57488
192.168.1.100
1433
9/14/2005 12:23:59 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57489
192.168.1.100
1433
9/14/2005 12:24:00 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57491
192.168.1.100
1433
9/14/2005 12:24:00 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Page:3/3
10/3/2005 3:53:57 PM
Audit Type
User
Client IP
Client Port
Server IP
Server Port
Date Time
Table Created
sa
192.168.1.7
57492
192.168.1.100
1433
9/14/2005 12:24:01 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57493
192.168.1.100
1433
9/14/2005 12:24:02 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57494
192.168.1.100
1433
9/14/2005 12:24:02 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57496
192.168.1.100
1433
9/14/2005 12:24:03 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57497
192.168.1.100
1433
9/14/2005 12:24:03 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57498
192.168.1.100
1433
9/14/2005 12:24:04 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57499
192.168.1.100
1433
9/14/2005 12:24:04 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57500
192.168.1.100
1433
9/14/2005 12:24:05 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57501
192.168.1.100
1433
9/14/2005 12:24:06 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57502
192.168.1.100
1433
9/14/2005 12:24:08 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))
Table Created
sa
192.168.1.7
57504
192.168.1.100
1433
9/14/2005 12:24:15 PM
SQL Query Text:
CREATE TABLE test1 ( testnum integer,, testcnt integer,, testname VARCHAR(14))