How to know my server name in SQL Server?

Question

I installed SQL Server but I forgot my server name and now that I install SQL Server Management Studio, it needs the server name.

How can I get server name again?

Answer 1

You can get your server name with Transact-SQL(T-SQL) as shown below:

SELECT @@SERVERNAME                    -- DESKTOP-OVPADTC\SQLEXPRESS
SELECT SERVERPROPERTY ('ServerName')   -- DESKTOP-OVPADTC\SQLEXPRESS