Hi All,
I want to find the version, SP applied (CU if any) applied on SQL server.
I am able to get verison no. using @@VERSION. But I want the whole list of patches/SP applied to it.
Can you please help me out.
Thanks, Sunil
+1
A:
This snippet of T-SQL gives you a bit more info on the version and features of your SQL Server - I do not know if there's any documented way to find all patches applied to a SQL Server from within it....
SELECT
SERVERPROPERTY('productversion') as 'Product Version',
SERVERPROPERTY('productlevel') as 'Patch Level',
SERVERPROPERTY('edition') as 'Product Edition',
SERVERPROPERTY('buildclrversion') as 'CLR Version',
SERVERPROPERTY('collation') as 'Default Collation',
SERVERPROPERTY('instancename') as 'Instance',
SERVERPROPERTY('lcid') as 'LCID',
SERVERPROPERTY('servername') as 'Server Name'
marc_s
2010-09-05 07:56:42
I know this option but it doesnt provide me detail information of all the SPs applied
Sunil Agarwal
2010-09-05 15:59:55
@Sunil Agarwal: as I said already, I do not think you can get this list from within SQL Server itself. You would have to query the Windows update log for any patches applied....
marc_s
2010-09-05 16:44:57
+1
A:
xp_msver tells you a lot.
To back track build (eg 4035 to SQL Server 2005 SP3) to hotfix, check this
Note: Service packs are cumulative. You can't tell if SP1 was applied separately if SP2 is applied. Hotfixes are cumulative at the SP level. So HF Q961930 (HF2) for SQL Server 2005 means SP2 must be installed but you can't assume that Q959195 (HF1) is applied
gbn
2010-09-05 07:58:08
Thanxs, but I want the whole list of patches/SP applied to particular sever. How can I get that list?
Sunil Agarwal
2010-09-05 15:59:31