Trace / Profile - returning DatabaseName and Success in SQL:StmtCompleted event

• tjaybelt

  SSCrazy

  Points: 2604

  More actions

  January 26, 2007 at 9:06 am

  #171188

  I have a trace that is watching for filtered values on the event SQL:StmtCompleted

   

  The following columns have been chosen to be returned in myu result set.

    ApplicationName

    DatabaseID

    NTUserName

    NTDomainName

    LoginName

    Duration

    HostName

    TextData

    SPID

    StartTime

    EndTime

    Success

   

  I am having trouble with the Success and DatabaseName columns.  No data comes back in these columns.  I have attempted many different configurations, even different events, and they do not come back.

   

   I have another set of traces that i have performed that successfully brings back the success flag.  These are in the Audit events though.  not in the SQL:StmtCompleted event class... 

   

  What am i missing ?

   

• Yelena Varshal

  SSC-Dedicated

  Points: 34287

  More actions

  January 26, 2007 at 1:28 pm

  #685951

  I use DB ID. For some reason i did not have luck even filtering on Database Name

  Regards,Yelena Varsha

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 26, 2007 at 1:33 pm

  #685953

  In profiler all columns will not work with all events...

  Some columns works with some events and some of them are...

  In 2005 MS improved it ... In 2005 when you click the event columns then the compatible columns will be automatically checked...

  MohammedU
  Microsoft SQL Server MVP