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

Here are the three different ways to know the Server name using queriesMethod 1 : Use @@servernameselect @@servername as server_nameMethod 2 : Use sp_helpserver system procedureexec sp_helpserver Read more: Beyond Relational Posted via email from .NET Info