DBA and SysAdmin World

December 9, 2008

How to Get SQL Server Version?

Filed under: SQL Server — Tags: , — solihinho @ 3:34 AM
Computer_time_to_upgrade Last time I faced problem with Sharepoint 2003 search. It is related to SQL Server 2000 Full Text Catalog. When I tried to get support from Microsoft, they do not support SQL Server 2000 SP3 anymore. Because of this cause, finally we upgraded our SQL Server 2000 to SP4. Yes, there are some problems after upgrading but my Sharepoint problem resolved by this upgrading and I am able to get support from Microsoft again if there is an issue on my database server in the future.

Nerd Before apply Service Pack, do not do it directly on production environment. Do it on development and testing environment first if possible. Find out other DBA issues from forum and prepare the solution. Prepare the worst case to downgrade the Service Pack ( usually the SQL Server need to reinstall)

Below script is to get version of the SQL Server

SELECT
   SERVERPROPERTY('servername') AS ServerName
,  SERVERPROPERTY('edition') AS Edition
,  SERVERPROPERTY('ProductVersion') AS ProductionVersion
,  SERVERPROPERTY('ProductLevel') AS ProductLevel

Values return on ProductLevel:

1. ‘RTM’ : Original Release Version
2. ‘SPn’ : Service Pack Version
3. ‘Bn’ : Beta Version
Advertisements

1 Comment »

  1. If 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

    Comment by tosc — December 9, 2008 @ 3:22 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

Create a free website or blog at WordPress.com.

%d bloggers like this: