SQL Profiler Database and Filename Missing Info

9 May 2005 3:08 PM

kat

I am using SQL Profiler. In the Data Columns I have chosen DatabaseName,
ApplicationName, and FileName. When running a trace, nothing displays in
these columns. Anyone else experience this?

--
Thanks.
Katherine

9 May 2005 3:58 PM

Tibor Karaszi

Not all events populated each column. What events are you looking at?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"kat" <kwalt***@smithnoble.com> wrote in message
news:B83EA51E-837B-4750-B963-99DC556218A9@microsoft.com...
>I am using SQL Profiler. In the Data Columns I have chosen DatabaseName,
> ApplicationName, and FileName. When running a trace, nothing displays in
> these columns. Anyone else experience this?
> --
> Thanks.
> Katherine

9 May 2005 4:10 PM

katherine walters

The events I am looking for are:
rpc:started
sp:started
DTCtransaction
SQLtransaction
ExecPreparedSQL
SQL:stmtStarting
AuditBackupRestoreEvent
Scan:Started

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

9 May 2005 4:20 PM

David Gugick

katherine walters wrote:

> The events I am looking for are:
> rpc:started
> sp:started
> DTCtransaction
> SQLtransaction
> ExecPreparedSQL
> SQL:stmtStarting
> AuditBackupRestoreEvent
> Scan:Started
>

DatabaseName is really only used by some of the Audit events. It is not
used by other events. You'll want to use the DatabaseID instead and
resolve those values in against master..sysdatabases or by using the
db_name() function.

--
David Gugick
Imceda Software
www.imceda.com

11 May 2005 6:22 PM

kat

--
katherine

Show quote Hide quote

"David Gugick" wrote:

> katherine walters wrote:
> > The events I am looking for are:
> > rpc:started
> > sp:started
> > DTCtransaction
> > SQLtransaction
> > ExecPreparedSQL
> > SQL:stmtStarting
> > AuditBackupRestoreEvent
> > Scan:Started
> >
>
> DatabaseName is really only used by some of the Audit events. It is not
> used by other events. You'll want to use the DatabaseID instead and
> resolve those values in against master..sysdatabases or by using the
> db_name() function.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
> Thank you much.