| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
| Created: | Tue Aug 23 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 275.1 | CSC32::HOEPNER | A closed mouth gathers no feet | Mon Sep 30 1996 19:29 | 4 | |
| 275.2 | 4.2.1.A | CHOWDA::ORR | Wed Oct 02 1996 10:09 | 6 | |
| 275.3 | LEXS01::PUCHRIK | Field Rat | Wed Oct 02 1996 23:45 | 22 | |
| 275.4 | thanks | CHOWDA::ORR | Thu Oct 03 1996 10:18 | 5 | |
| 275.5 | steps for changing sort order? | CHOWDA::ORR | Tue Oct 08 1996 10:11 | 16 | |
| 275.6 | GUIDUK::HEALY | Alan Healy @ZSO | Fri Feb 28 1997 14:45 | 11 | |
This is very late, but for the record...
When changing Sort Order, you should use bcp to copy the data out of
all databases rather than dump. When the new master database has been
rebuilt with the new sort order and the metadata re-created, the data
should be copied back in with bcp.
(Ref: SQL Server 6.0 Administrators' Companion, Chap. 3 - Configuring
Servers, "Rebuilding the Master Database")
Al
| |||||