You have been hired as the SQL administrator for your company. The IT director tells you that the company hasthree SQL servers: one SQL Server 2005 server and two SQL Server 2008 servers. He shows you where thecomputers are located. You need to determine the version and build number for the SQL Server 2008 servers. You also need todetermine the collation used by the server. From which location should you obtain this information?
A.
the General page of the SQL server’s Server Properties dialog box
B.
the Connections page of the SQL server’s Server Properties dialog box
C.
the Database Settings page of the SQL server’s Server Properties dialog box
D.
the Advanced page of the SQL server’s Server Properties dialog box
Explanation:
To determine the version and build number, as well as the server collation, for the SQL Server 2008 servers, youshould access the General page of the SQL server’s
Server Properties dialog box, as shown in the following image:You can also obtain this information by running the sp_server_info system stored procedure without anyparameters or passing the sp_server_info system stored procedure an
@attribute_id parameter value of 2. Forexample, you could use the following statement to display the version and build:
sp_server_info @attribute_id = 2
You cannot determine the version and build number or server collation for the SQL Server 2008 servers byaccessing the Connections page of the SQL server’s Server Properties
dialog box. This page allows you toconfigure different connection parameters, as shown in the following graphic:You cannot determine the version and build number or server collation for the SQL Server 2008 servers byaccessing the Database Settings page of the SQL server’s Server Properties dialog box. This page allows youto configure different database settings, including backup/recovery settings and default file locations. This page isshown in the following image:
You cannot determine the version and build number or server collation for the SQL Server 2008 servers byaccessing the Advanced page of the SQL server’s Server Properties
dialog box. This page allows you to viewmany advanced settings, including filestream, network, and parallelism settings. This page is shown in thefollowing image:Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Configure SQL Server instances.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > Server Properties F1 Help >Server Properties (General Page) – SQL Server Management Studio