|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Trace Procs: Object Name not showing up correctly in file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Trace Procs: Object Name not showing up correctly in file
|
|
| Charles Hawkins 2002-11-11, 2:23 pm |
| I have a trace running in the background on one of my SQL 2000 development
servers to look for object creations (eventclass 46) and object deletions
(eventclass 47). I'm capturing to a disk file, among other columns, the
object name, object owner, and database. The object owner and database are
always NULL. The object name is recorded. However, when I creat an object
with the object owner preceding the object name, as in "dbo.object_history",
instead of "object_history" being recorded in the trace file, "dbo" is
recorded in the trace file for the object name. This happens whether the
eventclass is 46 or 47.
Have I found a bug in the trace functionality? Is there a fix? I'm using SQL
2000 Service Pack 2 and the trace procs to create the trace and its
location, set the columns, set the eventclasses to monitor and filter out
events from tempDB.
Chuck Hawkins
charles.hawkins@compass.net
| |
| Charles Hawkins 2002-11-11, 3:23 pm |
| I found the problem. The object name is being recorded and I'm able to load
it up into a table using the function that reads traces as a recordset.
It's just when I look at the data in GRID mode in Query Analyzer, only DBO
shows up. When I look in TEXT mode, the name shows up. Now to see what
character is betweent he DBO and the name.
Case closed for now.
Chuck Hawkins
"Charles Hawkins" <charles.hawkins@compass.net> wrote in message
news:uYoMLtbiCHA.4128@tkmsftngp08...
> I have a trace running in the background on one of my SQL 2000 development
> servers to look for object creations (eventclass 46) and object deletions
> (eventclass 47). I'm capturing to a disk file, among other columns, the
> object name, object owner, and database. The object owner and database are
> always NULL. The object name is recorded. However, when I creat an object
> with the object owner preceding the object name, as in
"dbo.object_history",
> instead of "object_history" being recorded in the trace file, "dbo" is
> recorded in the trace file for the object name. This happens whether the
> eventclass is 46 or 47.
>
> Have I found a bug in the trace functionality? Is there a fix? I'm using
SQL
> 2000 Service Pack 2 and the trace procs to create the trace and its
> location, set the columns, set the eventclasses to monitor and filter out
> events from tempDB.
>
> Chuck Hawkins
> charles.hawkins@compass.net
>
>
|
|
|
|
|