my code

Snippet options

Download: Download snippet as check_version.sql.
Copy snippet: For this you need a free my code account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

/* @@version*/

/* serverproperty */
    SERVERPROPERTY('productversion') as ProductVersion,
    SERVERPROPERTY ('productlevel') as ProductLevel,
    SERVERPROPERTY ('edition') as Edition

/* @@microsoftversion */
SELECT CONVERT(varbinary,@@microsoftversion)

/* sp_server_info */
EXEC sp_server_info 2

/* xp_msver */
EXEC xp_msver 'ProductVersion'

Create a free my code account now.

my code is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.