469,081 Members | 1,436 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

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.
Mar 20 '08 #1
2 3748
Artie (ar*******@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, es****@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
Mar 20 '08 #2
I see them now. I did not look under System Extended Stored Procedures
Thanks.

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
Artie (ar*******@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, es****@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

Mar 20 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Guillermo_Lopez | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.