How to check SQL server patch level? 1

[zacca]

Hi there,

I'm very new to SQL server, vendor just help to built a MS SQL server for me.

How can I check if SQL SP3a is installed or not?

Many thanks!

 

[JayKusch]

run the following ...

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

then check your findings against the info at this link ...

http://www.tacktech.com/display.cfm?ttid=60

Thanks

J. Kusch

 

[JBaileys]

Run select @@version to get sql server version. Each version 8.00.xxx refers to the service pack

 

[zacca]

Hi Jay Kusch,

I run your procedures & got the info as follows:
SQL Server 8.00.760 - SP3 (Standard Edition)

Is this SP3 means SP3 only or SP3a?

Many thanks!

 

[JayKusch]

It could be either since SP3 and SP3a are both 8.00.760 versions. I know ... Confusing!

Thanks

J. Kusch

 

[zacca]

thx so much Jay! ;-)