Last night I tried to change the Navision Windows Collation (case sensitivity) related to our user db. After putting the user db in Single-User-Mode, we ran the client upgrade and the result was that it increased the db size by approx 2GB and filled up the db’s transaction log which is not 14GB! However, it didn’t change the case sensitivity of the database or the Navision application as far as we can tell.
Does anyone have any experience performing Navision’s Collation change?[:S]