Re: SQL Server 2005 Profiler Automated

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Joe K. (JoeK@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I inherited serveral SQL Server 2005 database servers. How can I
determine if the database servers have SQL Server 2005 Profiler set to
automated?

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@xxxxxxxxxxxxx

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/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Creating Primary key with ODBC
    ... > (Sorry for line confusion, ... Have you checked which version of the ODBC SQL Server driver you have? ...
    (comp.databases.ms-sqlserver)
  • Re: List availalbe SQL Servers?
    ... FWIW I have run that code on a computer where there is a default ... of SQL 2005 Express, and it only finds the SQL Server 2000 instance, ... I suppose you mean both the OLEDB/SQLNCLI Enumerator or SMO here? ... Sorry again for the confusion, I again meant using Vitali's code. ...
    (borland.public.delphi.database.ado)
  • SQL Server Licensing
    ... I have a small confusion in the way the licensing of SQL Server works. ... have a per processor license for my SQL Server 2000. ... Rest assured I will not be a bug on the phone.. ...
    (microsoft.public.sqlserver.server)