James works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer named bwSQL1 with the default collation settings. He installs SQL server 2005 on another computer named bwSQL2 with different collation settings. What will he do to configure bwSQL2 with the same collation settings as bwSQL1?
A. Reinstall SQL server 2005 on bwSQL2 with the same collation settings as bwSQL1.
B. Use the fn_get_sql function to change the collation settings.
C. Use the SQL Server properties dialog box in SSMS to change the collation settings.
D. Use the fn_helpcollation function to change the collation settings.
Answer:A
James works as a Database Administrator for Miracle Infocom. The company has a SQL server 2005 computer named bwSQL1 with the default collation settings. He installs SQL server 2005 on another computer named bwSQL2 with different collation settings. What will he do to configure bwSQL2 with the same collation settings as bwSQL1?
A. Reinstall SQL server 2005 on bwSQL2 with the same collation settings as bwSQL1. B. Use the fn_get_sql function to change the collation settings. C. Use the SQL Server properties dialog box in SSMS to change the collation settings. D. Use the fn_helpcollation function to change the collation settings.