Server information

USE MASTER

GO

DECLARE @listStr VARCHAR(8000)

SELECT @listStr = COALESCE(@listStr+',' , '') + ISNULL(NAME,'')

FROM SYSDATABASES  WHERE NAME NOT IN ('master', 'tempdb', 'model', 'msdb');

SELECT

CONVERT(sysname, SERVERPROPERTY('servername')) as SERVERNAME,

right(@@version, 44)  as OSVersion,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel,

SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('Collation') AS Collation,

SERVERPROPERTY('IsClustered') AS ClusterStatus,

SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NetBIOS,

@listStr AS DBNAMES;