SQL SERVER – Get Server Version and Additional Info

It is quite common to get the SQL Server version details from following query.


version1 SQL SERVER   Get Server Version and Additional Info

Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed.

EXEC xp_msver

version2 SQL SERVER   Get Server Version and Additional Info

Watch a 60 second video on this subject

I like to use the second one but again that is my preference.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

7 thoughts on “SQL SERVER – Get Server Version and Additional Info

  1. Hey Pinal,

    This may not be the right thread for such question/help, but I could not find any other.

    Actually I am trying to install SQL Server 2005 Enterprise Edition (x32) on Windows 7 (64 bit), but getting lot of errors like Asp.Net is not registered with IIS etc.

    Please guide me as how can I install it successfully. Do I need to do some settings before installing SQL Server – 32 bit on Windows 7 – 64 bit ?

    Please help …!

    Munish Bansal


  2. Hi Pinal
    how to see the latest version info in sql
    for example
    if i am using 2005 sql server,
    i want the information about latest product (2012 RCO) like that

    Thanks in advance


  3. Pingback: SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video « SQL Server Journey with SQL Authority

  4. Hi i need get the Platform of sql then compare this platform with the platmform of OS im using C# but i dont would use fuction SUBSTRING() I WISH A SINGLE SQL SINTAX


  5. From the article, I see how to get the SQL Server version and edition, as well as the Windows version.

    Is there a way to get the Windows Edition name (Enterprise vs Standard, etc)?



  6. Hi all

    How could we found BULK INSERT completion percentage in SQL server using C#?

    I have tried with the following query:

    SELECT d.name databasename,
    estimated_finish_time = DATEADD(MILLISECOND,estimated_completion_time, CURRENT_TIMESTAMP) FROM sys.dm_exec_requests r INNER JOIN sys.databases d ON r.database_id = d.database_id WHERE r.command like ‘%BULK INSERT%’

    But I am unable to get the result as per the requirement.


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