I inherited serveral SQL Server 2005 database servers. How can I determine
if the database servers have SQL Server 2005 Profiler set to automated?

Thanks,

Joe K. (JoeK (AT) discussions (DOT) microsoft.com) writes:
Ehum, I may be in a state of confusion, but I don't really know what
you mean. Profiler is a tool, and not a property on the server, and I
can't really think of what it would mean that it's set to automated?

Maybe you could clarify?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

What exactly do you mean by that? There is no way to automate Profiler. You
can create traces and automate them but I need to know more of what you are
looking for.

--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Joe K." <JoeK (AT) discussions (DOT) microsoft.com> wrote

You can list server side traces by querying sys.traces. Note that this will
also include the default trace, if enabled.

SELECT * FROM sys.traces;

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/