missing stored procedures in model

Hello:
we just noticed that there are no stored procedures in model.
We restored from tape from many months ago and there were none then.
Question #1: I thought model had some stored procedures
if so
Question#2: since I cannot restore, how can I rebuild the model database
Thanks
TThe absence of SPs is ok for me, becasue the model db is only a
template for further created databases, such as tempdb at the server
start. If youdidn=B4t create any procedures in here, there won=B4t be
any.
HTH, Jens Suessmeyer.|||So none come natively ?
Thanks
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126698473.378221.321270@.f14g2000cwb.googlegroups.com...
The absence of SPs is ok for me, becasue the model db is only a
template for further created databases, such as tempdb at the server
start. If youdidn´t create any procedures in here, there won´t be
any.
HTH, Jens Suessmeyer.|||Correct, Model does not contain any stored procedures unless you put them
there.
"Support" wrote:
> So none come natively ?
> Thanks
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1126698473.378221.321270@.f14g2000cwb.googlegroups.com...
> The absence of SPs is ok for me, becasue the model db is only a
> template for further created databases, such as tempdb at the server
> start. If youdidn´t create any procedures in here, there won´t be
> any.
> HTH, Jens Suessmeyer.
>
>|||say this because in other databases, I have stored procedures like:
dt_addtosourcecontrol
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_whocheckedout
that are all system sprocs
T
"Support" <RemoveThis_Support@.mail.oci.state.ga.us> wrote in message
news:euPpNMSuFHA.3684@.TK2MSFTNGP09.phx.gbl...
> So none come natively ?
> Thanks
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1126698473.378221.321270@.f14g2000cwb.googlegroups.com...
> The absence of SPs is ok for me, becasue the model db is only a
> template for further created databases, such as tempdb at the server
> start. If youdidn´t create any procedures in here, there won´t be
> any.
> HTH, Jens Suessmeyer.
>|||I checked a number of our servers to verify.
"Support" wrote:
> say this because in other databases, I have stored procedures like:
> dt_addtosourcecontrol
> dt_adduserobject
> dt_adduserobject_vcs
> dt_checkinobject
> dt_whocheckedout
> that are all system sprocs
> T
>
>
> "Support" <RemoveThis_Support@.mail.oci.state.ga.us> wrote in message
> news:euPpNMSuFHA.3684@.TK2MSFTNGP09.phx.gbl...
> > So none come natively ?
> > Thanks
> > "Jens" <Jens@.sqlserver2005.de> wrote in message
> > news:1126698473.378221.321270@.f14g2000cwb.googlegroups.com...
> > The absence of SPs is ok for me, becasue the model db is only a
> > template for further created databases, such as tempdb at the server
> > start. If youdidn´t create any procedures in here, there won´t be
> > any.
> >
> > HTH, Jens Suessmeyer.
> >
> >
>
>|||By default the model database contains no stored procedures.
The dt_ procedures are added the first time you select ADD Diagram. The
same for the table dt_properties.
M