TMACUL

MS SQL looking for Server Name / SQL Version / Collation

Blog Post created by TMACUL Champion on Dec 4, 2015

select @@SERVERNAME

Ex: CASDMDBSERVER

 

select @@version

Ex:

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)

  Dec 28 2012 20:23:12

  Copyright (c) Microsoft Corporation

  Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

 

select convert(varchar, SERVERPROPERTY('collation'));

EX: SQL_Latin1_General_CP1_CI_AS

Outcomes