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.

Artie (artie2269@yahoo.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@sommarskog.se

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

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

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A67BAA4DF74AYazorman@127.0.0.1...
> Artie (artie2269@yahoo.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@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx