Which service pack do I have installed?
Related to previous post's, sometimes it is helpful to quickly determine SQL Server's service pack level.
By selecting @@VERSION
in a query window ...
SELECT @@VERSION AS "SQL Server Version"
you / I get following result:
SQL Server Version
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 6.0 (Build 6000: )
From this, you can quickly determine that I'm running SQL Server 2005 Developer Edition version 9.00.3054.00 on an Intel X86 processor, OS Windows NT 6.0 (Vista). It may also appear - after the Build number - a Service Pack number, but this referes to the operating system and not to the SQL Server system.
To determine SQL Server's service pack level, use the built-in SERVERPROPERTY function. And a little bit more conclusive with appropriate parameters - EDITION, PRODUCTLEVEL, and PRODUCTVERSION.
SELECT SERVERPROPERTY('EDITION')
SELECT SERVERPROPERTY('ProductLevel')
SELECT SERVERPROPERTY('ProductVersion')
The following result appears:
Developer Edition
(1 Zeile(n) betroffen)
SP2
(1 Zeile(n) betroffen)
9.00.3054.00
(1 Zeile(n) betroffen)
And probably you want a deep dive, therfore you can use the extended stored procedure xp_msver [ optname ]
USE master
EXEC xp_msver; --- without optname for the whole result
GO
CU tosc
Print article | This entry was posted by tosc on 2008-04-03 at 15:29:24 . Follow any responses to this post through RSS 2.0. |
Tag cloud
administration backup «best practices» books bug configuration ctp «cumulative update» demo denali dmv ebook humor index indexoptimize integrity kbfix links maintenance «ms sql server 2008» pass performance php profiler reviews «ross mistry» «service pack» «service pack 2» «service pack 3» «service packs» sharepoint «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack «stacia misner» t-sql technet «technical note» tempdb tools «trace flag» version whitepapers