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

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 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.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 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

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

Missing entry in sysfulltextcatalogs

Hi
I've just restored a database from a backup, usually I have to correct the
path of the fulltext index in master.sysfulltextcatalogs after doing this,
but now sysfulltextcatalogs is empty and has no entries. When I right click
the table with the fulltext index I can see that it has a fulltext index
defined.
Has anyone got an idea of what's going on, why is sysfulltextcatalogs
showing up as empty?
Kind Regards,
Allan Ebdrup
I am confused, you restored a database from a backup and you expect the
sysfulltextcatalog table to contain an entry for this catalog?
I take it that the original backup was done on this machine and is not from
a remote server, and that the database have tables which were full text
indexed before you restored the backup.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>
|||BTW - don't you mean you have to correct the path in the database's
sysfulltextcatalogs as opposed to master's?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>