-
Changing Collation of Server
I need to change the default collation of all dbs on all my servers to SQL_Latin1_General_CP1_CI_AI from SQL_Latin1_General_CP1_CI_AS. We need to do compares and sorts and want to ignore accents -- something that wasn't clear when we built the servers. I know this has to do with "re-building databases" -- maybe even including the master -- but I'm not certain exactly what this means. Thanks!
-
Changing Collation of Server (reply)
Run rebuildm.exe from /mssql7/binn folder.
------------
at 3/15/01 10:43:58 AM
I need to change the default collation of all dbs on all my servers to SQL_Latin1_General_CP1_CI_AI from SQL_Latin1_General_CP1_CI_AS. We need to do compares and sorts and want to ignore accents -- something that wasn't clear when we built the servers. I know this has to do with "re-building databases" -- maybe even including the master -- but I'm not certain exactly what this means. Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|