{handshake sound}

Query Sql Version Microsoft MSSQL

    set nocount on
    go
    select @@version
    go
    select 'Edition: ' + convert(char(30), serverproperty('Edition'))
    go  
    select 'Product Version: ' + convert(char(20), serverproperty('ProductVersion'))
    go
    select 'Product Level: ' + convert(char(20),serverproperty('ProductLevel'))
    go
    set nocount off
    go

References
https://support.microsoft.com/kb/321185

http://blogs.msdn.com/b/euanga/archive/2008/01/23/confused-by-sql-server-version-numbers.aspx

Ronnie Diaz Avatar

Published by

Ronnie Diaz
Ronnie Diaz is a software engineer and tech consultant with over a decade of experience building software and systems. Ronnie started his career in ecommerce, service industries and remote education. He transitioned from traditional desktop client-server applications through early cloud development. Software included human resource management and service technician workflows, online retail e-commerce and electronic ordering and fulfillment, IVR customer relational systems, and video streaming remote learning SCORM web applications. Hands on server experience and software performance optimization led to creation of a small business focused on collocated web hosting and data center services. This led to specialized expertise in large file storage and video streaming and opened the door at Amazon Prime Video. Ronnie now builds and leads teams to build software and systems which stream live sports and events for millions of viewers around the world.
Categories:
Tags: , , , , , , , , ,

Leave a comment