Re: SQL Server 2000 Audit for login

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Fri, 27 Jan 2006 22:53:44 +0000 (UTC)

Jacand4321 (jacand4321@xxxxxxxxx) writes:
> Thanks Tony for the reply. I'm wondering, if it is going to add any
> significant overhead on the database.

As long as you only catch login events, there is not too much overhead.

However, it's better to use a server-side trace and trace to a file, and
this is leaner on resources. Look up the sp_trace procedures in Books
Online.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- SQL Server 2000 Audit for login
  - From: Jacand4321
- Re: SQL Server 2000 Audit for login
  - From: Tony Rogerson
- Re: SQL Server 2000 Audit for login
  - From: Jacand4321

Prev by Date: Re: Views vs Stored Procedures, whats the difference?
Next by Date: Re: SQL Server does not exist or access denied
Previous by thread: Re: SQL Server 2000 Audit for login
Next by thread: MS Access Frontend for remote sql server
Index(es):
- Date
- Thread

Relevant Pages

Re: Activity Monitoring for a Single Table
... A server-side trace as Aaron suggested gives you the offending statement ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)
Re: SQL Server 2005 - Server side trace script
... If I have a server-side trace, and open it in Profiler, TextData is ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)
Re: Track changes made to SQL Server
... I need the data intact:( ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ... What do you mean profile on a server-side trace? ...
(comp.databases.ms-sqlserver)
Re: Getting the database name in Server-Side trace event
... > I'm trying to audit all the database activities using Server-side trace ... The database name is not always populated, ... The place to look in Books Online is ... Administering SQL Server ...
(comp.databases.ms-sqlserver)
Re: Query training -- Complex queries
... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
(microsoft.public.sqlserver.server)