You are the SQL administrator for your company. You manage a SQL Server 2008 instance named SQL1 thathosts several databases.
SQL1 was originally configured to use a SQL Server collation. You need to change theinstance to a Windows collation.
You create scripts for creating all the user databases and the objects in them. Then, you export all your data anddrop all user databases. What should you do next?
A.
Rebuild the master database with the new collation, and import your data.
B.
Rebuild the master database with the new collation, create the user databases and objects using the scripts,and import your data.
C.
Rebuild the master database with the new collation, and create the user databases and objects using the scripts.
D.
Rebuild the master database with the new collation, import your data, and create the user databases and objects using the scripts.
Explanation:
You should rebuild the master database with the new collation, create the user databases and objects using thescripts, and import your data. This will ensure that all future user databases will use the new collation. It will alsoensure that the current user databases are changed to use the new collation. The data should be imported afterthe collation is changed and the user databases have been created. All other options are incorrect because they do not specify the required steps in the correct order or because theydo not include all the steps needed.
Objective:
Performing Data Management TasksSub-Objective:
Manage collations.References:
TechNet>TechNet Library>Server Products and Technologies>SQL Server>SQL Server 2008>ProductDocumentation>SQL Server 2008 Books Online>Database Engine>Development>Querying and ChangingData>International Considerations for Databases and Database Engine Applications>Working withCollations>Setting and Changing Collations>Setting and Changing the Server Collation