Multiple choice technology databases

Which of the below commands is used to find more information about the SQL Server installed such as edition, product level etc. ?

  1. Select * from sys.servers

  2. sp_get_serverinfo

  3. select @@version

  4. sp_serverproperty
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The @@version global variable returns complete version information including edition, product level (RTM, SP, CTP), and build number. The other options are either non-existent stored procedures or return server configuration rather than version details.

Keep practicing — related questions