Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Operating Systems & Databases (http://www.baanboard.com/baanboard/forumdisplay.php?f=4)
-   -   how to change collation name on baandb database (SQL 2000 Server) (http://www.baanboard.com/baanboard/showthread.php?t=13553)

nopadon 10th November 2003 12:30

how to change collation name on baandb database (SQL 2000 Server)
 
Dear Sir,

we have some problem one local character. baandb return local character to ?????? . so we cannot read it.
so we would like to change collation name to new.
but we not idea how to change it on SQL 2000 Server.

we have to try to rebuild master (rebuildm.exe) . but rebuildm will copy x86/data/ master.mdf , .... model.mdf.... but and rebuild all to new collation name. but baandb nerver change it. how to change collation baandb on SQL server.


holply anyone can help me.

Regards
Nopadon

Note. Oracle we change solve this problem by modify registry value Name is NLS_LANG and change Value data but SQL 2000 Server, as I know can do only change collation name.


All times are GMT +2. The time now is 21:45.


vB.Sponsors
©2001-2018 - Baanboard.com - Baanforums.com