InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 21:16:23 GMT20http://www.sqlservercentral.com/Forums/Topic1409330-1550-1.aspxThanks much, it works.Tue, 22 Jan 2013 09:14:43 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1409330-1550-1.aspx[quote][b]sqlfriends (1/20/2013)[/b][hr]Is there a way to find out what traces are enabled in a sql server instance?and also what is the default traces that are turned on?Thanks[/quote][code="sql"]-- all tracesSELECT * FROM sys.traces;-- the default traceSELECT * FROM sys.traces WHERE is_default = 1;[/code]Sun, 20 Jan 2013 22:32:15 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1409330-1550-1.aspxIs there a way to find out what traces are enabled in a sql server instance?and also what is the default traces that are turned on?ThanksSun, 20 Jan 2013 17:39:37 GMTsqlfriends