Sevice Pack Version

Question

Post reply

Sevice Pack Version

sqlquery-101401

SSCarpal Tunnel

Points: 4951
More actions
December 4, 2003 at 4:14 am

#81683

when i look my service pack version of my sqlsever by typing Select @@version it gives me sp4 but i think that is o/s service pack,plz suggest how i can see my sql server
service pack version.
thanx

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

SELECT @@version is just fine.

See http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18417

You can compare your result with this here http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

sqlquery-101401 SSCarpal Tunnel Points: 4951 More actions · Answer 2

but through em it shows sp3 why it shows sp4 in select @@version

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Are you sure you're looking both ways at the same server?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

Here is the readout of a SQL Server:

Microsoft SQL Server  2000 - 8.00.818 (Intel X86)   

Dec 17 2002 14:22:05   

Copyright (c) 1988-2003 Microsoft Corporation  

Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

The section that tells you what version of SQL Server is this one:

Microsoft SQL Server  2000 - 8.00.818 (Intel X86)   

Dec 17 2002 14:22:05   

Copyright (c) 1988-2003 Microsoft Corporation  

Developer Edition

The significant portion you are looking for is the number that looks like 8.00.818 because it is this number that tells you the Service Pack + Hotfix level.

Using SELECT @@VERSION also tells you the OS and its service pack. That's the portion found:

Windows NT 5.0 (Build 2195: Service Pack 4)

From this I know the SQL Server is running on a Windows 2000 system (albeit I don't know if it's Professional, Server, etc.) and I know that the OS has SP4 applied.

So you get both both info about SQL Server and the OS using @@VERSION.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Edited for Frank.

Edited by - bkelley on 12/04/2003 07:06:07 AM

K. Brian Kelley
@kbriankelley

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

Did I ever mention I hate horizontal scrolling

SELECT @@version returns here in full



                                                                        

------------------------------------------------------------------------

Microsoft SQL Server  2000 - 8.00.760 (Intel X86) 

Dec 17 2002 14:22:05 

Copyright (c) 1988-2003 Microsoft Corporation

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)





(1 row(s) affected)

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]