Home > Archive > SQL server exams > January 2002 > Changing sort order, char set, unicode collation after installation





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Changing sort order, char set, unicode collation after installation
slam

2002-01-02, 10:37 pm

If I want to change sort order, char set, unicode collation after installation, I can rebuid master db using "rebuildm" utility; from the study guide I'm using, it recommends sysadmin to "backup object definitions you wish to preserve by using Enterprise Manager to create scripts" before rebuilding master. Where can I find these object definitions in EM console? How can I create scripts? I want to try that at home soon.
hard_coder

2002-01-03, 3:54 pm

In the EM, right click on the Database you wish to script, then "All Tasks", then "Generate SQL Script..." This gives you tabs to select the objects to script.
Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net