September 14, 2009 at 9:12 am
Hello Guys,
My Prod SQL Server box is having the follwoing version:
-------------------------------
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
----------------------------------
I would like to know what are the recommended patches ( hot fixes / Security patches / IPAKs) has to be applied to above version of sql server. Also i want to know how do i check if those patches are already installed or not?
Regards
Jus
September 14, 2009 at 9:17 am
Jus (9/14/2009)
Hello Guys,My Prod SQL Server box is having the follwoing version:
-------------------------------
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
----------------------------------
I would like to know what are the recommended patches ( hot fixes / Security patches / IPAKs) has to be applied to above version of sql server. Also i want to know how do i check if those patches are already installed or not?
Regards
Jus
this is one of the links to a site that lists build information
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
I would suggest that you patch to service pack 3 as minimum, always better to rollup to latest service pack, as it is normally fully tested and all the updates have been rolled in the service pack.
normally running
select @@version
will give you all you need.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply