Artie (ar*******@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,
es****@sommarsk og.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