By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,017 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,017 IT Pros & Developers. It's quick & easy.

Getting the database name in Server-Side trace event

P: n/a
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?

Thanks in advance.
J

Feb 1 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Jacand4321 (ja********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 1 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.