Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sql Profiler not showing DATABASE NAME in trace output
185 views
Skip to first unread message
Juanita Drobish
Mar 17, 2004, 12:06:07 PM3/17/04
to
HI. I'm running standard traces and one of the data columns i want is the DATABASE NAME. When i run the trace the DATABASE NAME is comes out blank. I executed some simple SELECT stmts to make sure i am accessing some databases and still no DATABASE NAME appears in the trace. i have NO filters set to cause this.
can someone help me here?
thanks,
Juanita Drobish
Jasper Smith
Mar 17, 2004, 12:21:20 PM3/17/04
to
Database Name only shows up for a certain nuber of events (mainly security
events if I recall) You need to use database id which will show up for
selects etc. You can find the id of a database using select db_id('database
name') or by looking in master.dbo.sysdatabases
events if I recall) You need to use database id which will show up for
selects etc. You can find the id of a database using select db_id('database
name') or by looking in master.dbo.sysdatabases
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Juanita Drobish" <anon...@discussions.microsoft.com> wrote in message
news:49E0725A-3A7A-44E1...@microsoft.com...
0 new messages