??????SQL Server2000????????校??卸???????????master??model??msdb??tempdb???????master??????????????????娲�????SQL Server???????????????????????????????????????谩?????????????????????????????械??????????????????????????????????????master??????????????????????????????????????????master????????????????????????????????????????????????????????????????????
???????????master?????
????1:master??????????????
??????????????锟�???????master?????
?????????????????????
???????/???????????????????????????????????????????????????????
????????????????????????????????????????
???????????????婕�?????????????????????眉??????master??
????2:master??????????
???????????锟�?master???????眉????????????master??????????????????????
?????????????????????????????
???????????master?????????路
???????master?????????SQL Server???????????????????????锌???????????master?????????????????????
??????????????锟�???????master?????
???????master???????路??????????????????2??瑁�
????1????????master?????????SQL Server???????????????
????2?????SQL Server?????????????????????????SQL Server????????????????
????3???????????????master???????
????4???????????SQL Server???????????????????
???????????master???????????
????1??????rebuildm.exe???????master?????
?????霉???????SQL Server????????????????????????路?????
????C:Program FilesMicrosoft SQL Server80ToolsBinn
???????懈霉??????????????master?????校????煤??????????????SQL Server???????????????
???????SQL Server 2000????????master???????路???????????


??????????????????????????????????????????????northwind??pubs??
??????????????????????????谩?
?????????????????????????????????????SQL Server????????
?????????????????SQL Server??????????dbo????????????????sa??????????????????
?????????械????????????????
????2????SQL Server????????????????
??????SQL Server????????????????????????????????????????????????????????????“????”
??????“????????”????“????”??????“???????”????“???????”?????“-m”?????????????


????3???????????????master???????
???????煤????????????????SQL Server???????????????master????????
?????????????????????????????谢??


?????????????????????????T-SQL??????谢????


??????????????????????谢?????????????????????些????????????
??????????貌????????????谢??????????????????????
????4???????????SQL Server???????????????
??????????????????SQL Server??????????2?????????????????-m??
???????????SQL Server????????????????????????????械?????????????????
???????????????????????????
???????
????????master??????model??msdb??????????????
????????master????????????????????model??msdb?????
?????????????????????
?????????????????????model??????msdb????????????????????
????model??????????????????????????tempdb?????????澹�?魏?????????????????model??????????
????Msdb???????SQLSERVER2000???????????????????????????
???????????????????????SQL Server????????????????
?????????model?????????????????????????澹�???model????????????SQL Server???????????
??????????????锟�??????????master?????????????位??master??model??msdb?????
???????????????master???????????????
???????胁???????msdb?????????????SQL Server?????????????????????????????????谢???????????