SQL, Usefull, Commands

SQL, Usefull, Commands

SELECT @@SERVERNAME AS ServerName;

GO

SELECT @@VERSION AS VersionInfo;

GO

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion,

       SERVERPROPERTY('Edition') AS Edition,

       SERVERPROPERTY('EngineEdition') AS EngineEditionID,

       SERVERPROPERTY('ProductLevel') AS ProductLevel,

       SERVERPROPERTY('Collation') AS Collation,

       SERVERPROPERTY('InstanceName') AS InstanceName,

       SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerName;

GO