February 5, 2010 at 10:14 am
From Event Class for Errorlog in SQL Server 2005 there is an ApplicationName Data column which is sometimes NON-Null depending on event. I want to see it. How do I query or view this column?
Zee - SS DBA
Atlanta GA:-)
February 5, 2010 at 10:58 am
Are you talking about a SQL Trace?
you can select out of a trace by using this method:
http://www.sqlservercentral.com/Forums/Topic859816-146-1.aspx#bm859881
Craig Outcalt
February 5, 2010 at 11:19 am
So I would have to run a Profiler Trace 7 x 24 if I need to capture that metadata for all security-type events (login, logout, connections, etc.)?
We are running an auditing application that captures SQL Server events called InTrust (Quest). It goes wacky when we run Profiler, so I'm not sure I can do that.
Perhaps InTrust might capture that column (I'm not the staff that runs and monitors InTrust).
Zee
February 5, 2010 at 1:13 pm
I think some of the information you want is in the default trace which is always running on SQL Server.
Not really sure because you were not all that descriptive in your OP.
Server side traces do not impact system performance unless it's an extremely indiscrete trace.
You would know if they did because like I said... the default trace is always running.
Profiler traces do very much impact system performance because it queries the trace provider constantly and pushes rowset data across the network.
Craig Outcalt
February 5, 2010 at 2:59 pm
Craig,
What is query to run to ensure default trace NOT disabled, and to determine where it would be located. One of my SS instances did NOT have a Log folder in the place it is normally installed MSSQL.1\MSSQL\LOG. It was a normal install of SS otherwise.
Can the default trace containing the ApplicationName be filtered or configured in any way?
Thx,
Zee
February 5, 2010 at 7:30 pm
This should be all the basic info for the default trace.
select * from :: fn_trace_getinfo(0)
where traceid=1
Craig Outcalt
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply