Query SQL version via server management studio

Open SQL Server Managment Studio
Connect to the database
Click "New Query"
Paste the code
SELECT
SERVERPROPERTY('productversion') as 'Product Version',
SERVERPROPERTY('productlevel') as 'Service Pack', 
SERVERPROPERTY('edition') as 'Edition',
SERVERPROPERTY('instancename') as 'Instance',
SERVERPROPERTY('servername') as 'Server Name'
Execute the query
You got result:

No comments: