Jul 13
Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS , Serverproperty( 'Edition' ) as Edition , Serverproperty( 'InstanceName' ) as InstanceName , Serverproperty( 'IsClustered' ) as IsClustered , Serverproperty( 'MachineName' ) as MachineName , Serverproperty( 'ProductVersion' ) as ProductVersion , Serverproperty( 'ProductLevel' ) as ProductLevel , Serverproperty( 'ResourceLastUpdateDateTime' ) as ResourceLastUpdateDateTime , Serverproperty( 'ResourceVersion' ) as ResourceVersion , Serverproperty( 'ServerName' ) as ServerName , USER_ID() AS [USER_ID] , USER_NAME() AS [USER_NAME] , SUSER_ID() AS [SUSER_ID] , SUSER_SNAME() AS [SUSER_SNAME] , IS_SRVROLEMEMBER ('sysadmin') AS [Is_ServerAdmin_Sysadmin] , ORIGINAL_LOGIN() AS [ORIGINAL_LOGIN]
