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
T
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=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.googlegr oups.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 youdidnt create any procedures in here, there wont 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.googlegr oups.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.googlegr oups.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 youdidnt create any procedures in here, there wont 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...
>
>
|||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