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:
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.