SQL Server version information and SP patch Information viewing method _mssql

Open SQL Server Configuration Manager, then double-click the Open Properties dialog box with the left mouse button, and then select the Advanced tab to see the version information

Often used the following statements to look at version information, SP version, now double-click the mouse can be seen, the most important is to facilitate customers, no reason to ask customers to write SQL statements to see it

Copy Code code as follows:

SELECT serverproperty (' edition ')
SELECT serverproperty (' ProductLevel ')