Welcome to the World of SQLServer.........
Eat SQL, Drink SQL, Sleep SQL
Thursday, November 15, 2012
To find out any traces are running on SQL Server?
To find out any traces are running on SQL Server?
Following query will list you the total number of traces (default and custom) which are running on a SQL server.
SELECT *
FROM fn_trace_getinfo(default);
GO
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment