Change Windows Sorting Options after creating a SQLServer DB

nav_user

Hi Forum!!!

is it possible to change the Windows Sorting Options after the creation of a Navision DB in SQL Server???

Question in detail:

I´ve created a new Nav DB with my Navision Client at our SQL-Server Testsystem. At the Options-Tab "Sorting" i choose "Windows Sorting" as Option. Is it possible to change these Windows Sorting Options even if i created the DB?

Thanks for answers.
please excuse the poor english.... 8-[

kine

If you are using MS SQL 2000 or later, you can change collation after creating the DB. DB must be in single user mode before you want to change this. Look into menu File - Database - Alter - Collation....

nav_user

Thx for your reply!!

I've got it.