How to get SQLServer version, release, edition?

— @@version – Get version, product version/release, 32 or 64 bit
Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

— SERVERPROPERTY('productversion') – Product version/release
— SERVERPROPERTY ('productlevel') – Product level (RTM –
— SERVERPROPERTY ('edition') – Product Edition (Developer, Standard, Enterprise)
Documentation on SERVERPROPERTY
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.1399.06 RTM Developer Edition

One comment

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.