Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
david32
Starting Member
15 Posts |
 Posted - 2008-08-02 : 23:18:04
|
| Hi Folks,I am having trouble deciding on collations for my new SQL2005 box. I think this is important as I am going to need to restore a database from a SQL2000 box My SQL server 2000 box say I am using Latin1_General_CI_AS server collation. I may be wrong but because this does not have SQL in front of it.. it seems like a windows collation. I thought SQL 2000 only had SQL collations not windows collations. Can you use a windows collation on a 2005 box if you are trying to restore a db from a 2000 box? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-02 : 23:23:56
|
| That is valid sql collation. |
 |
|
|
david32
Starting Member
15 Posts |
Posted - 2008-08-02 : 23:47:09
|
| thanks but I need more info there.. are you saying Latin1_General_CI_AS is a valid SQL collation as my SQL 2000 server collation? If so the question I need answered is: when installing 2005 with the view of restoring databases from my 2000 box onto this server Can I choose a windows collation that specifies Latin1_General_CI_AS or do I have to choose a SQL collation (which there seems to be multiple Latin1_General_CI_AS collations). If I need to choose a SQL collation how do I go about choosing the right Latin1_general_ci_as. My regional setting on the 2000 box are: English and Language: Western Europe United States.thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-02 : 23:52:34
|
| Just use the default collation, it'll save you a lot of grief especially when in the U.S. Yes there are SQL collations and Windows collations that are valid in SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-04 : 02:36:31
|
| which collation has the backup set, after restoring, the same collation will be taken to the restored databaseArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
collations