---

Search posts under SQL Server:

---

Knowing SQL Server version in SQL Server

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