Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
I am missing the whole of MSDB, or just some tables - how do I create them?
Neil Pike
February 4, 2000
1 Min Read
A. A. In the INSTALL directory are the scripts that SQL runs itself to create the MSDB database and it's tables. Before running these make sure the devices/files for msdb are there and create them if not.
The scripts you need to run are :-
instmsdb.sql
servrmsgs.sql
web.sql
These are most easily run with ISQL/W or ISQL/OSQL.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)