Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to use SQL Server Management Studio 2008's Activity Monitor with an SQL Server 2000 instance to diagnose some query performance issues. I can connect SMSS 2008 to the db fine, and use it to browse objects and run queries. But when I press the Activity Monitor button, it pops up an error message saying:

Microsoft SQL Server Management Studio
This operation does not support connections to Microsoft SQL Server Personal Edition version 8.00.818.

This MSDN article implies that Activity Monitor works with SQL Server 2000. Is it the fact that it's Personal Edition that's preventing it from working? The error message isn't clear whether it's the edition or version that's the problem.

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

No it does not - the verbiage in Books online appears misleading

share|improve this answer
    
I can confirm that this does not work when I try to connect from Management Studio 2008 Activity Monitor to my SQL Server 2000 Enterprise instance. –  Sean Howat Apr 16 '10 at 15:55
    
Agreed. I even have a hard time getting it to work with SQL 2005. –  squillman Apr 16 '10 at 16:24
add comment

I have a SQL 2000 Enterprise database, can confirm that I can SELECT from sysprocesses and syslocks and get "This operation does not support connections to Microsoft SQL Server Enterprise Edition version 8.00.2039." when trying open Activity Monitor.

I presume that the MSDN article is incorrect. And it likely does not work due to the absence of DMV's.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.