Strategy Management

This section must be completed if you have an existing English database. If you are creating a new database, the collation is automatically set.

1. Start Microsoft SQL Server Management Studio and log on as a system administrator.
2. Open a query window and specify this information:

Use [DATABASE]
ALTER TABLE [ContentObjs] DROP CONSTRAINT
UQ_CONTENTOBJS_NAME_USERNAME

ALTER DATABASE [Database Name] COLLATE Language;

/* Dimension tables */
ALTER TABLE [Accum] ALTER column mem_name varchar(100) COLLATE Language
ALTER TABLE [Accum] ALTER column mem_desc varchar(255) COLLATE Language
ALTER TABLE [Measure] ALTER column mem_name varchar(100) COLLATE
		Language
ALTER TABLE [Measure] ALTER column mem_desc varchar(255) COLLATE
		Language
ALTER TABLE [Period] ALTER column mem_name varchar(100) COLLATE Language
ALTER TABLE [Period] ALTER column mem_desc varchar(255) COLLATE Language
ALTER TABLE [PlanObject] ALTER column mem_name varchar(100) COLLATE
		Language
ALTER TABLE [PlanObject] ALTER column mem_desc varchar(255) COLLATE
		Language
ALTER TABLE [Scenario] ALTER column mem_name varchar(100) COLLATE
		Language
ALTER TABLE [Scenario] ALTER column mem_desc varchar(255) COLLATE
		Language
ALTER TABLE [Unit] ALTER column mem_name varchar(100) COLLATE Language
ALTER TABLE [Unit] ALTER column mem_desc varchar(255) COLLATE Language
ALTER TABLE [Variable] ALTER column mem_name varchar(100) COLLATE
		Language
ALTER TABLE [Variable] ALTER column mem_desc varchar(255) COLLATE
		Language

/* Other tables */
ALTER TABLE [ContentObjGroups] ALTER column description varchar(100)
		COLLATE Language
ALTER TABLE [ContentObjGroups] ALTER column description varchar(255)
		COLLATE Language
ALTER TABLE [ContentObjs] ALTER column name varchar(100) COLLATE
		Language
ALTER TABLE [ContentObjs] ALTER column description varchar(255) COLLATE
		Language
ALTER TABLE [ContentObjs] ALTER column Title varchar(100) COLLATE
		Language
ALTER TABLE [ContentObjs] ALTER column TopText varchar(100) COLLATE
		Language
ALTER TABLE [ContentObjs] ALTER column BottomText varchar(100) COLLATE
		Language
ALTER TABLE [ContentObjs] ALTER column UserName varchar(50) COLLATE
		Language
ALTER TABLE [ContentObjStyles] ALTER column name varchar(100) COLLATE
		Language
ALTER TABLE [ExtractInfo] ALTER column ReportName varchar(50) COLLATE
		Language
ALTER TABLE [MeasureColorStyles] ALTER column name varchar(100) COLLATE
		Language
ALTER TABLE [PlanObjTypes] ALTER column name varchar(20) COLLATE
		Language
ALTER TABLE [PlanObjTypes] ALTER column description varchar(255) COLLATE
		Language
ALTER TABLE [PropertyInfo] ALTER column alias varchar(100) COLLATE
		Language
ALTER TABLE [ContentObjs] ADD CONSTRAINT UQ_CONTENTOBJS_NAME_USERNAME
		UNIQUE NONCLUSTERED (Name,UserName)

where Database Name is the name of the database and Language is the language you are going to test. Database Name is the same as the Plan Name.

CI stands for case insensitive. AS stands for accent sensitive.

If you encounter issues with data that is not displaying correctly in the sample databases, you should re-import the data.