February 22, 2005 at 3:23 am
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
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
Ok, thanx
subban
February 23, 2005 at 9:03 am
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