Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql server  - Database Collation and Server Collation Different

Posted on 2009-07-02
4
Medium Priority
?
307 Views
Last Modified: 2012-05-07
I have just restored a copy of a database created by a third party company on a second server so I can test it.

When I ran into the inevitable problems, the 3rd party support guy looked at it and said that I should expect problems because the database collation (SQL_Latin1_General_CP1_CI_AS) was different from the server collation (Latin1_General_CI_AS). He said that if I reconciled the server collation to the database collation (not the reverse) it would be just fine.

I am familiar with the concept of collation but have the following questions:

1. How to change the server collation to SQL_Latin1_General_CP1_CI_AS ?

2. Why might it matter that the two are different?

I don't want to change anything if I don't have to as rumour has it that the process is rather messy.

TIA

Hopeful Kiwi
0
Comment
Question by:kiwi_731
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 840 total points
ID: 24763586
if you want to change collation of sql server itself, follow the below link

http://blogs.digineer.com/blogs/jasons/archive/2007/10/18/change-sql-server-collation.aspx

if you want to change collation of only one database than

alter database dbname collate SQL_LATIN_GENERAL1_CI_AS
0
 

Author Comment

by:kiwi_731
ID: 24858580
Hi Ritesh

Sorry about the long delay, due to the fact that I am dependent on other people to put the changes through for me.

I will assign points as soon as I know how they have got on.

Hopeful Kiwi
0
 

Accepted Solution

by:
kiwi_731 earned 0 total points
ID: 24983098
Hi Ritesh

The IT people have finally come back. I posted them the link http://msdn.microsoft.com/en-us/library/ms179254(SQL.90).aspx from one of the comments under the thread that you mentioned , and they managed OK. They created a separate server instance with the corrected collation as there was already another database on the physical server which they didn't want to disturb.

Thanks for your help.

Hopeful Kiwi
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 25011494
glad to know that you are now free from this problem.

Ritesh Shah

http://www.SQLHub.com 
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question