server and service pack version

[adonet]

how to know service pack version? I use "select @@version" only get server version but no service pack

 

[SQLBill]

You get at funky number don't you?

Go to

http://www.sqlsecurity.com

click on the FAQs/Docs link
select the SQL Server Version Database

That will 'interpret' the results you get from @@version.

You can also find the information on Microsoft's website.

-SQLBill

 

[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