Logon triggers
- From: Hugo <Hugo@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 18 Aug 2008 02:16:01 -0700
Hello,
I am searching for the best way to log all logins using sysadmin users. I
want to record the time, username, hostname and application-name. There are
to many users with sysadmin rights and I need some for info from the system
before changing that. I am running SQL 2005 SP2.
I am looking at logon triggers, but I understand that if the trigger fails
(like when my audit table is unavailable) no one (or at least no sysadmins)
will have access to the server. Is this correct? How to resolve?
Thank you very much,
Hugo
.
- Follow-Ups:
- Re: Logon triggers
- From: Erland Sommarskog
- Re: Logon triggers
- From: Uri Dimant
- Re: Logon triggers
- Prev by Date: Error: 15466, Severity: 16, State: 1.
- Next by Date: Re: Logon triggers
- Previous by thread: Error: 15466, Severity: 16, State: 1.
- Next by thread: Re: Logon triggers
- Index(es):
Relevant Pages
|
