server roles

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Sir,

We are 10 system administrators in SQL Server with different user names with SA equivalent. How could we know if someone of us sabotage our SQL Server. Is there a way to show what each everyone of us performed or executed.

Thanks.

-- Anonymous, November 13, 1999

Answers

Aurora,

The best you can do is to use SQL Trace to record SQL statements as they are executed. SQL Trace allows you to track the name of the computer running each statement which will help in identifying a saboteur. SQL Trace also allows filtering, so perhaps you would not have to record everything.

Hope this helps,

Eric

-- Anonymous, November 13, 1999


Moderation questions? read the FAQ