Cannot access SQL Server 2000 Activity Monitor in SQL Server 2008 or above

Posted on by
Reply

If you are using SQL Server Management Studio in SQL Server 2008, 2008 R2 or above, you can acces the previous versions of SQL Servers from the Management Studio as shown in the picture below. I am using SSMS in SQL Server Code-Named Denali (CTP 3) and I am connected to a SQL Instance of the same version as that of the Management Studio. I am also connected to another SQL Server which is SQL Server 2000.

In order to open the activity monitor, I right-click on the connected server (SQL 2000 here…) and choose Activity Monitor from the popup menu.

We get the following error indicating that we cannot access activity monitor of SQL Server 2000 instance inside Management Studio.

The reason for this is, SQL Server Activity Monitor in SQL Server 2008 and above, utilizes the Dynamic Management Views (DMVs) introduced in SQL Server 2005. Whereas, activity monitor in SSMS 2005 is designed for backward compatible so that we can still be able to work with SQL Server 2000.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

SQL Server Management Studio in Denali

Posted on by
Reply

Microsoft has released Community Technology Preview 3 (CTP3) for its next version of SQL Server code named Denali. As I had done in the past, I downloaded a copy and started exploring the new release. The below screen shot is the splash screen for the Management studio.  

 

 

There are plenty of new features in this version of release. I look forward to share those as I stumble upon them.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

SQL Server 2008 R2 Service Pack 1

Posted on by
Reply

Service Pack 1 for SQL Server 2008 R2 has been recently released and available to download for SQL Server customers / users. You can download the Service Pack from http://www.microsoft.com/download/en/details.aspx?id=26727.

There are certain enhancements for SQL Server 2008 R2 product along with fixing a lot of known bugs in the RTM. The Service pack is released in all 3 major hardware platforms (X86,X64 and Ia64) and it is applicable for almost all Editions of SQL Servers.

For a list of known bugs that are addressed in the Service Pack 1, refer this knowledge base article http://support.microsoft.com/kb/2528583

As always whenever a service pack is applied on a mission critical system, it is suggested practice that you test the service pack thoroughly in a test environment.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

– Bru Medishetty