post SP2 GDR

I have a question about the post SP2 GDR that just came out in the last day or two. My laptop only has the client tools installed, not the server components (except for the SSIS server component). Is there any need for me to install this GDR? Does it impact the Management Studio code which views maintenance plans on remote SQL Servers or anything?

The information about the reason for the update of SQL Server SP2 is contained here:

http://support.microsoft.com/kb/933508/en-us

The basic summary is that if you use SQL Server 2005 Database Maintenance plans (not legacy plans from a migration) which use cleanup intervals, and you have edited those plans with the original SP2 tools, then these intervals may have been "corrupted".

You should install the GDR patch if you have the admin tools, and if you have updated such plans on your server with the original SP2 patch you should, once the GDR is installed, edit those plans and check/correct the cleanup intervals.

|||

Thanks for the reply. I wasn't asking what the patch did, I was wondering whether it was necessary to install on my laptop which only had the management tools and not an instance of SQL Server.

This discussion is unimportant now as Windows Update, just this morning, had me install an 18MB update to fix this very issue.

post SP2 GDR

I have a question about the post SP2 GDR that just came out in the last day or two. My laptop only has the client tools installed, not the server components (except for the SSIS server component). Is there any need for me to install this GDR? Does it impact the Management Studio code which views maintenance plans on remote SQL Servers or anything?

The information about the reason for the update of SQL Server SP2 is contained here:

http://support.microsoft.com/kb/933508/en-us

The basic summary is that if you use SQL Server 2005 Database Maintenance plans (not legacy plans from a migration) which use cleanup intervals, and you have edited those plans with the original SP2 tools, then these intervals may have been "corrupted".

You should install the GDR patch if you have the admin tools, and if you have updated such plans on your server with the original SP2 patch you should, once the GDR is installed, edit those plans and check/correct the cleanup intervals.

|||

Thanks for the reply. I wasn't asking what the patch did, I was wondering whether it was necessary to install on my laptop which only had the management tools and not an instance of SQL Server.

This discussion is unimportant now as Windows Update, just this morning, had me install an 18MB update to fix this very issue.