How to Know SQL Server Version?

Run `SELECT @@VERSION;`

Run `SELECT SERVERPROPERTY(‘ProductVersion’);`

Run `SELECT SERVERPROPERTY(‘ProductLevel’);`

Run `SELECT SERVERPROPERTY(‘Edition’);`

Run `SELECT SERVERPROPERTY(‘ProductMajorVersion’);`

Run `SELECT SERVERPROPERTY(‘ProductMinorVersion’);`

Run `SELECT SERVERPROPERTY(‘ProductBuild’);`

Use SQL Server Management Studio: connect to the server and check the server properties

Use `SELECT @@MICROSOFTVERSION;`

Suggested for You

Trending Today