By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,375 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,375 IT Pros & Developers. It's quick & easy.

SQL 2005 Workgroup Edition - how to run a trace

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.