Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

collation mismatch on columns between instances

Status
Not open for further replies.
blom0344

blom0344

Technical User
Mar 20, 2002
3,441
NL
When restoring a database backup to an SQL server 2005 instance (9.0.1399 patch) all nvarchar and ntext columns are build with a specified collation type. (that should not be there at all)
When restoring to 2 other SQL server instances (9.0.3077) the database is restored without specific collation types on columns. (like we expect and appreciate :) )

The database has collation type Lithuanian_CI_AS, in 2 schema's this is used for column collation, but the third schema throws Latin1_General in our face.

Is this an early 2005 bug of some kind. am I missing something.

Please , your input is appreciated

Ties Blom

 
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
167
TheBugSlayer
TheBugSlayer
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
168
JScannell
JScannell
lavadan
  • Locked
  • Question
current max value of all int columns
Replies
1
Views
96
fredericofonseca
fredericofonseca
Farrukh hameed
  • Locked
  • Helpful tip
Single Connection string control multiple database connection on case condtion
Replies
1
Views
160
fredericofonseca
fredericofonseca
awaria
  • Locked
  • Question
Automate nightly database data transfer between SQL environments on different servers
Replies
3
Views
70
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top