SQL Server Database Operations

Table

CREATE

<date_time> Created[/Modified] <table_name> Table <table ID> <initiator>

—

DROP

<date_time> Deleted <table_name> Table <table ID> <initiator>

—

ALTER

<date_time> Column added <table_name> Table <table ID> <initiator>

—

INSERT INTO

<date_time> Inserted row <table_name>[/table_ID] Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

DELETE FROM

<date_time> Deleted row <table_name>[/table_ID] Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

UPDATE

<date_time> Modified <table_name>>[/table_ID] Table <initiator>

Table name will not be displayed for deleted table, only table ID will be shown.

TRUNCATE

<date_time> Truncated Table <initiator>

Table name and ID will not be displayed for deleted table.

BULK INSERT

<date_time> Inserted row <table_name>[/table_ID] Table <initiator>

—

View

CREATE

<date_time> Created <view_name> View <initiator>

—

DROP

<date_time> Deleted <view_name> Table <initiator>

—

ALTER

<date_time> Modified <view_name> View <initiator>

—

Index

CREATE

<date_time> Created <index_name> Index <initiator>

—

DROP

<date_time> Deleted <index_name> Index <initiator>

—

ALTER

<date_time> Modified <index_name> Index <initiator>

—

Procedure

CREATE

<date_time> Created <procedure_name> Procedure <initiator>

—

DROP

<date_time> Deleted <procedure_name> Table <initiator>

—

ALTER

<date_time> Modified <procedure_name> Procedure <initiator>

—

Function

CREATE

<date_time> Created <function_name> Function <initiator>

—

DROP

<date_time> Deleted <function_name> Table <initiator>

—

ALTER

<date_time> Modified <function_name> Function <initiator>

—

Schema

CREATE

<date_time> Created <schema_name> Schema <initiator>

—

DROP

<date_time> Deleted <schema_name> Schema <initiator>

—

ALTER

<date_time> Modified <schema_name> Schema <initiator>

Schema cannot be detected.

User

CREATE

<date_time> Created <user_name> User <initiator>

—

DROP

<date_time> Deleted <user_name> User <initiator>

—

ALTER

<date_time> Modified <user_name> User <initiator>

—

Trigger

CREATE

<date_time> Created <trigger_name> Trigger <initiator>

—

DROP

<date_time> Deleted <trigger_name> Trigger <initiator>

—

ALTER

<date_time> Modified <trigger_name> Trigger <initiator>

—