November 29, 2010 at 12:03 pm
I am installing a named instance on (SQL Server 2005 (64bit) Standard Edition)
I need to mimic an existing installation which has the following collation:
Latin1_General_CP1_CI_AI
During the install I choose SQL_Latin1_General and the final product is a collation of Latin1_General_CI_AI
What check marks do I have to use in order to get Latin1_General_CP1_CI_AI???
Thank you!!!
November 29, 2010 at 12:08 pm
You have to specify the code page, 1252.
See here:
http://msdn.microsoft.com/en-us/library/ms180175.aspx
Future note, easily located via google. Search sql server collation CP1. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 29, 2010 at 12:21 pm
Thank you. I missed that in the drop-down.. and your link helped : )
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply