Get the Installed SQL Server Name and Version?

Updated on August 30, 2015 Kisan Patel

This tutorial will show you how to know the installed SQL Server name and version?

To get server name @@SERVERNAME and to get the version of SQL Server installed @@VERSION function can be used.

SELECT @@SERVERNAME, @@VERSION

Similarly, we can also use MAX connection allowed and max text size function like below

SELECT @@MAX_CONNECTIONS
SELECT @@TEXTSIZE

SQL Server

« Previous