RAM + RTC +SQL Server 2008 collator question...
Hi again,
I have a customer who wants to use the same SQL Server 2008 instance to host the 3 databases needed to support RAM (LifeCycles+Assets) + RTC (Jazz).
The customer wants to know if they install SQL Server 2008 using the Latin1_General_CI_AS collator, but then create each of the three databases using their prerequisite collators (so the LifeCycles and Jazz databases would be using SQL_Latin1_General_CP437_CS_AS and the Assets database would use Latin1_General_100_BIN2 (but I posted this question http://jazz.net/forums/viewtopic.php?t=11592 to find out if this is accurate)
Many thanks
Andy
I have a customer who wants to use the same SQL Server 2008 instance to host the 3 databases needed to support RAM (LifeCycles+Assets) + RTC (Jazz).
The customer wants to know if they install SQL Server 2008 using the Latin1_General_CI_AS collator, but then create each of the three databases using their prerequisite collators (so the LifeCycles and Jazz databases would be using SQL_Latin1_General_CP437_CS_AS and the Assets database would use Latin1_General_100_BIN2 (but I posted this question http://jazz.net/forums/viewtopic.php?t=11592 to find out if this is accurate)
Many thanks
Andy