Link to home
Start Free TrialLog in
Avatar of sahkeah
sahkeah

asked on

How do you change the default username for default SQL Trace

Hello,
I noticed in the sql logs that in this entry -

SQL trace ID 1 was started by login "sa"

How do I change the user or login for the default sql trace getting automatically started?
Meaning, I don't want the instance using the user = 'sa' to login, etc.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rk_india1
rk_india1
Flag of India image
Hi,

I agrred with the rrjegan17 cooment. It is right that you can off trace but can not change the login.

Default Trace in SQL Server 2005
When i saw *SQL Trace ID 1 was started by login "sa" * in my Error Log I was little surprised. Since i have never started any trace I was wondering what is this all about. Then i came to know that this is the default trace started which is a new feature introduced in SQL Server 2005. Then i was curious about how can i see the contents. here we go...


To See All the Trace and its location :
select * from ::fn_trace_getinfo(default)

To get the File Location
select * from ::fn_trace_getinfo(default) where Property=2

And copy paste the Value column text.

To Get the Trace Data

SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default) where starttime>'2009-12-26'