Is there a way to audit who is adding or removing logins?

Felipe,

If you are on SQL Server 2005 or later, use the DDL triggers to track
changes to the Logins.
This is discussed in part here:
http://technet.microsoft.com/en-us/library/ms189799(SQL.90).aspx

CREATE TRIGGER TriggerName
ON ALL SERVER
FOR ...
AS ...

If you are running SQL Server 2000, about the only way is to run a SQL Trace
that audits the "Audit AddLogin Event" under "Security Audit". This still
works on later versions of SQL Server as well.

RLF

"Carlos Felipe França da Fonseca" wrote in
message
> Some logins were removed from a SQL Server instance.
> Is there a way to audit who is doing that?
>
> Thanks,
>
> Felipe
>
 >> Stay informed about: Is there a way to audit who is adding or removing logins?