Microsoft
70-432 · Question #173
You maintain multiple SQL Server 2008 instances. You develop a failure recovery strategy. You need to find out the edition and the build of SQL Server that is deployed in your environment. What…
The correct answer is A. SELECT @@VERSION. See the full explanation below for the reasoning.
Question
You maintain multiple SQL Server 2008 instances. You develop a failure recovery strategy. You need to find out the edition and the build of SQL Server that is deployed in your environment. What should you use to find the required information?
Options
- ASELECT @@VERSION
- BSELECT * FROM sys.dm_os_sys_info
- CDBCC HELP
- DEXEC xp_msver
How the community answered
(28 responses)- A82% (23)
- B4% (1)
- C4% (1)
- D11% (3)
Community Discussion
No community discussion yet for this question.