Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 trace

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-12-19 : 09:51:00
i have question on SQL 2000
i run this query on SERVER (sql 2000)
SELECT * FROM ::fn_trace_getinfo(default)

when i run
EXEC sp_trace_setstatus @traceid = 1 , @status = 0

i stop the server engine.why this defualt trce need to run in my server? should i stop it?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-19 : 11:41:56
I leave the default trace enabled on most servers.

Have a look at these:

http://blogs.technet.com/b/vipulshah/archive/2007/04/16/default-trace-in-sql-server-2005.aspx

http://msdn.microsoft.com/en-us/library/ms175513.aspx


EDIT: are you talking about SQL 2000, or 2008?
Go to Top of Page
   

- Advertisement -