: I know that switching between a case sensitive and case insensitve server
: using Sybase is a major issue, actually I belive I was told it is
: impossible. However I am at a NT MS SQL Server based client who now feels
: that his case sensitive server is causing his people headaches and would
: like to switch to case insensitive. If anyone has actually performed the
: switch on NT or knows if it is impossible your help would be very much
To change the sort order you *must* re-install NT MS SQL Server. All
of the system tables, etc are built based on the defined sort order.
Be very careful when changing the default sort order. Once we re-installed
to change the sort order and 'OK'd when we should have 'Done'd or something
and the server came up in the default sort order--Very frustrating :(.
Sort order is a big decision, since servers with different sort orders cannot
share backups and will have problems sharing data ('Smith' and 'SMITH'
are distinct values for case-sensitive, and the same for case-insensitive).
(in search of a cool signature file...)