??????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?????????????????????????????????л???????????