Updated on 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
