find out server name ,hostname and instance details + SQL Server

Posted by Bandi under Sql Server category on | Points: 40 | Views : 347
The below system functions, system variables and system procedure gives the basic info of the server

select serverproperty('servername'), @@servername ServerName
select serverproperty('machinename'), HOST_name() HostName
select @@version
exec xp_msver -- to all details about MSSQL

Comments or Responses

Login to post response