TSQL Tips and Tricks - Different ways to know the server name

Here are the three different ways to know the Server name using queries
Method 1 : Use @@servername
select @@servername as server_name
Method 2 : Use sp_helpserver system procedure
exec sp_helpserver
Read more: Beyond Relational

Posted via email from .NET Info