August 2, 2006 at 3:03 am
Windows XP Professional - SQL Server 2005 Developer's Edition.
I use a PC in the UK, but require SQL 2005 to be installed with US settings - specifically SQL_Latin1_General_CP1_CI_AS, otherwise SQL Server complains about collation conflicts when I attempt to update some of the SPs.
2005 no longer has Rebuildm.exe and I'm having no fun whatsoever attempting to re-run the setup from the MSDN DVD as detailed within BOL, so had removed and reinstalled SQL, with a view to choosing the correct collation at installaion.
However the list of collations available doesn't exactly match the name of the one I'm after.
Could anybody tell me which collation I need to select at installation to get CP1_CI_AS, or what the trick is to getting the rebuild to work?
Thanks for any assistance,
Steve.
August 2, 2006 at 3:17 am
I'd really advise you to recollate your databases to the windows collation, however, the collation setting is on the collations settings install page - choose a sql collation rather than the collation designator and sort order.
You might find the ms SQL Server 2005 administrator's pocket consultant useful. isbn 13: 978-0-7356-2107-7
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply