How to get server name in sql server?

3 answer(s)
Answer # 1 #
  1. The output will display the server name. You can also find it in the 'Connect to Server' dialog when opening SSMS.
[5 Month]
Answer # 2 #

To get the server name in SQL Server:

[5 Month]
Answer # 3 #
  1. Open SQL Server Management Studio (SSMS). 2. Execute the query:
    sqlSELECT @@SERVERNAME
[5 Month]