MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips

Welcome to MSSQLTips Sign in | Join | Help

MSSQLTips » Tip Forums » Tip Discussions » Default Trace in SQL Server 2005

Default Trace in SQL Server 2005

Last post 08-21-2009 4:01 AM by nparikh. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

11-15-2006 12:00 AM

admin
Joined on 10-08-2007
Posts 1,155

Default Trace in SQL Server 2005

Reply Contact

This post is related to this tip: Default Trace in SQL Server 2005

http://www.mssqltips.com/tip.asp?tip=1111

06-05-2008 11:15 AM In reply to

trooper665
Joined on 06-05-2008
Posts 1

Re: Default Trace in SQL Server 2005

Reply Contact

When I check sp_configure the default trace is configured, however when I run SELECT * FROM fn_trace_getinfo(default) nothing is returned. I just took ownership of this server so any past activity could have happened. Does anyone know what happened here?

08-21-2009 4:01 AM In reply to

nparikh
Joined on 08-21-2009
Posts 1

Re: Default Trace in SQL Server 2005

Reply Contact

I have tried the code you have provided for serverside trace but i am facing strange problem - events and column filters provided not being recognised and trace contains all events and columns. Is there any specific configuration needs to be taken care to handle this?

Thanks

Page 1 of 1 (3 items)