Posted by Erland Sommarskog on 02/02/06 00:49

Jacand4321 (jacand4321@yahoo.com) writes:
> I'm trying to audit all the database activities using Server-side trace
> in SQL Server 2000.
> Basically I need to get the login information (login Id, Login time
> etc) along with the name of the database.Can some one suggest a way to
> do that?

You can find in Books Online exactly which columns that are populated for
which events. The database name is not always populated, but in such
case the database ID usually is. What I do when I analyse trace files is
that I load them into a table, and then supplement columns like database
name and object name, when only the ID is present. (In some cases, not
even the object id is populated, in which case I try to extract it from
TextData.)

The place to look in Books Online is
Administering SQL Server
Monitoring Server Performance and Activity
Monitoring with SQL Profiler
Monitoring with SQL Profiler Event Categories

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

[Back to original message]