Q:

Restore Missing Objects in SQL Server MASTER Table

We had an issue where we were missing Stored Procedures in our SQL 2008 MSDB table - ran the script in the install folder called instmsdb.sql and all objects were back.
Is there a similar script to add all objects back to the MASTER table?

A:

The documentation describes how to rebuild all system databases including master; you use the setup program, not a SQL script. But rebuilding the system databases completely recreates them as if you had just installed SQL Server, so the better solution is always to back up your system databases.
(I'm assuming that you're on SQL 2008, based on your tags; please always mention the version of SQL Server that you have.)

