Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSMS Update

Author  Topic 

rbarlow
Starting Member

26 Posts

Posted - 2009-01-21 : 17:23:00
I've recently found a server that appears to have missed getting Management Studio patched when SP2 was installed. I want to update it because there seems to be several bugs with the 9.00.1399 version.

Will doing this require a restart to the server? I'm pretty sure it doesn't but I want to make sure since its production.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-21 : 17:31:40
It sometimes requires a restart but usually doesn't. You could always defer the reboot until later though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rbarlow
Starting Member

26 Posts

Posted - 2009-01-21 : 17:33:57
Thanks for your quick response.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-21 : 17:38:42
You're welcome. I wouldn't worry about SP2 being applied to the client tools on the database server too much as the recommendation is to not run the client tools from the server anyway. I would just ensure that the client tools on the client machine are updated and then update the server component during your next scheduled maintenance window.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -