When I ran the following SQL on my DB server,
select SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')
9.00.3077.00 SP2 Standard Edition
Then ran select @@version the result is,
Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86) Dec 17 2008 15:19:45 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
If I follow the following URL,
I can see my version number in it with Date Published: 2/10/2009.
I didn't apply any patches this year at all. It might have been updated automatically. Do you recommend automatic updates on SQL Server DB's? How to enable or disable automatic updates or is it get applied as part of the Windows Update or Microsoft Updates?
As I can see on the updates on my server the last entry is
GDR 3077 for SQL Server Database SErvices 2005 ENU (KB960089) installed on 28/02/2009. The same for Integration Services, Notification Services, Tools and Workstation Components, Analysis Services, Reporting Services.
The one entry before these entry is KB921896 which is dated 02/08/2007.
Any help is appreciated in guiding me in the right track in terms of SQL Server patching as I could see lots of MS articles and is bit confusing. Btw, How do I get notified on new patches other than keep visiting the sites or the site mentioned by SA?
What is the best way forward for me on patching my SQL Server DB's going forward?