Identifying version of SQL Server

(Figure-1)


(Figure-2)

Many organizations have multiple SQL Server systems installed, and now that Microsoft has released different service packs, chances of running multiple versions is high. This can be a problem because some features require a minimum service pack level.

For Example, Database mirroring requires a minimum of SQL Server SP1

To determine what version of SQL Server is running, execute below Query in Query Editor (Figure 1): -

SELECT @@version

To retrieve complete product information, execute below query (Figure 2): -

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'),
SERVERPROPERTY('edition')