October 2, 2009 at 8:47 am
Hi all!
I posted few times about different issues, but this is new for me.
About 4 years ago I've created a database Library in Access, transfered it to SQL Server, using Upsize Wizard. Everything worked fine since...
At beggining, let me say that I have 4 tables: BasicData, Books, Members, Loans.
Since I live in Serbia I put database collation to be SQL_Latin..., hoping that by using some converters I could convert some letters to Cyrillic. Few days ago I realized that this is not such good idea, so I decided to alter collation into Cyrillic_General_CI_AS. I right-clicked database, and on Option tab I tried to make collation to be Cyrillic_General_CI_AS. I've got a message like:
Could not alter collation to Cyrillic_General_CI_AS, because database object Members.MemberFName has the same collation as database. That object is column of table Member.
Problem is that object Members.MemberFName is dependeing by collation with database. It is asking me to remove dependency and then try to alter database collation.
Please advise me how to remove dependency of object from whole database.
Sincerely yours,
priest Ivan Delic, Serbia
October 2, 2009 at 8:56 am
I think what I'd do is create a separate database, with the collation you want, and import objects and data into it through SSIS. That way, you can test applications, etc., on the copy, without potentially breaking anything.
Once you're happy with the copy, make it the main database.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 2, 2009 at 9:28 am
Thanks a lot for quick answer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply