Post reply

Object Name in SQL Profiler

  • February 22, 2005 at 3:23 am

    #85478

    Hai,

    How to get object name (table, procedures) in the sql profiler trace.

    In the trace events i have added 'TSQL: SQL Batch complted' and in the columns 'object name' is added. but while running the trace the object name fieled is always blank, can anybody explain this ??

     


    subban

  • February 22, 2005 at 6:42 am

    #543445

    From what I can tell it only works for a few items such as items under Objects events, Stored Procedures events and Transactions events. I have never seen work for any of the TSQL items.

  • February 22, 2005 at 8:11 am

    #543473

    Ok, thanx


    subban

  • February 23, 2005 at 9:03 am

    #543732

    Use ObjectID. Then you can use sysobjects in the database to get object name.


    Carl Davis

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply