SQL 2005 Workgroup Edition - how to run a trace

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Artie
    #1

    SQL 2005 Workgroup Edition - how to run a trace

    I need to run a trace on a SQL 2005 Workgroup Edition. Profiler is only
    available in Standard and Enterprise?
    SQL 2005 BOL refers to serveral SPs and functions for tracing but I don't
    have those in my workgroup edition.
    Any other options? Can I connect a SQL 2000 Profiler to 2005?

    Thanks.


    Tags: None
    • Erland Sommarskog
      #2
      Re: SQL 2005 Workgroup Edition - how to run a trace

      Artie (artie2269@yaho o.com) writes:
      I need to run a trace on a SQL 2005 Workgroup Edition. Profiler is only
      available in Standard and Enterprise?
      SQL 2005 BOL refers to serveral SPs and functions for tracing but I don't
      have those in my workgroup edition.
      Any other options? Can I connect a SQL 2000 Profiler to 2005?
      No, you cannot connect with Profiler 2000 to any edition of SQL 2005.

      I'm a little mystified when you say that you don't have the procedures
      and functions for tracing on your Workgroup Edition. I don't have any
      access to any instance of Workgroup Edition, but I have an instance of
      SQL Express, and this seems to work:

      declare @d int
      exec sp_trace_create @d OUTPUT, 1
      select @d

      Further more, it returns 2 when I run it, which indicates that the
      default trace is running.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • Artie
          #3
          Re: SQL 2005 Workgroup Edition - how to run a trace

          I see them now. I did not look under System Extended Stored Procedures
          Thanks.

          "Erland Sommarskog" <esquel@sommars kog.sewrote in message
          news:Xns9A67BAA 4DF74AYazorman@ 127.0.0.1...
          Artie (artie2269@yaho o.com) writes:
          >I need to run a trace on a SQL 2005 Workgroup Edition. Profiler is only
          >available in Standard and Enterprise?
          >SQL 2005 BOL refers to serveral SPs and functions for tracing but I don't
          >have those in my workgroup edition.
          >Any other options? Can I connect a SQL 2000 Profiler to 2005?
          >
          No, you cannot connect with Profiler 2000 to any edition of SQL 2005.
          >
          I'm a little mystified when you say that you don't have the procedures
          and functions for tracing on your Workgroup Edition. I don't have any
          access to any instance of Workgroup Edition, but I have an instance of
          SQL Express, and this seems to work:
          >
          declare @d int
          exec sp_trace_create @d OUTPUT, 1
          select @d
          >
          Further more, it returns 2 when I run it, which indicates that the
          default trace is running.
          >
          >
          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
          >
          Books Online for SQL Server 2005 at
          http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

          Books Online for SQL Server 2000 at
          http://www.microsoft.com/sql/prodinf...ons/books.mspx

            Comment

            Previous template Next
            Working...