How to check SQL Server Version Or Build No?


Option 1
EXEC master..sp_MSgetversion
Output
Character_Value
——————– ———– ———–
10.0.2789.0 1 3

Option 2
select @@version
Output
Microsoft SQL Server 2008 (SP1) – 10.0.2789.0 (X64)
Jul 12 2010 19:21:29
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Option 3
SELECT SERVERPROPERTY('productversion')
Output Build Version
10.0.2789.0

Option 5
SELECT SERVERPROPERTY ('productlevel')
Output-Service Pack
SP1

Option 6
SELECT SERVERPROPERTY ('edition')
Output-Edition
Enterprise Edition (64-bit)

Advertisements

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s