What’s up SQL – Number 2 – SQL Server Version

Hello reader.

 

Did you ever had to look up for the SQL Server version you are using?

Me too. Here’s how I do it.

 

Open a new query in SQL Server Management Studio and type:

SELECT @@VERSION
GO
The result will be something like this:
“Microsoft SQL Server 2008 R2 (SP1) – 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) “
If you need more information you can also use the Stored Procedure sp_server_info, to get information like system collation.

Leave a Reply

Your email address will not be published. Required fields are marked *