This article is half-done without your Comment! *** Please share your thoughts via Comment ***
If you are SQL DBA and if you faced any SQL DBA interview in your career, I am 99% sure that Interviewer had asked this question like “How to get the SQL Server version information.”
Most of you guys are thinking a common answer like answer is: "SELECT @@VERSION"
Yes, this is a correct answer, but you can add
"EXEC xp_msver"in your reply which will add more value because using xp_msver you can get detail information of your SQL Server like version, language, memory, product name, file version and much more.
Since the beginning of SQL Server, a xp_msver is available, and it is also easy to remember the name of this stored procedure so you can add in your answer.
All the best! If you like this question, please share your experience via comment…
Check the below sample result of xp_msver:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
Index Name Internal_Value Character_Value ------ -------------------------------- -------------- ---------------------------------------------------------- 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 851968 13.0.1400.361 3 Language 1033 English (United States) 4 Platform NULL NT x64 5 Comments NULL SQL 6 CompanyName NULL Microsoft Corporation 7 FileDescription NULL SQL Server Windows NT - 64 Bit 8 FileVersion NULL 2015.0130.1400.361 ((SQL_Main).160409-0127) 9 InternalName NULL SQLSERVR 10 LegalCopyright NULL Microsoft Corp. All rights reserved. 11 LegalTrademarks NULL Microsoft SQL Server is a registered trademark of Microsoft Corporation. 12 OriginalFilename NULL SQLSERVR.EXE 13 PrivateBuild NULL NULL 14 SpecialBuild 91750761 NULL 15 WindowsVersion 91750761 6.3 (9600) 16 ProcessorCount 1 1 17 ProcessorActiveMask NULL 1 18 ProcessorType 8664 NULL 19 PhysicalMemory 16383 16383 (17179336704) 20 Product ID NULL NULL |
