Model Database Stored procedures are gone.

SQL Server 2000 SP3a. Just noticed that the stored procedures that were in
the model database are gone. So any new databases will not contain these st
ored procedures. Is this a problem?
Thanks,
WarrenWe cannot answer that question for you. That is a question that you =
must answer. =20
If stored procedures were placed within the model database I would =
expect that something or someone expects those stored procedures to be =
available in the user databases that are created. =20
It is easy enough to create the stored procedures...simply grab the =
scripts and execute them in each database...then add them to model so =
that they will exist within new databases as they are created.
--=20
Keith
"Warren" <Warren@.discussions.microsoft.com> wrote in message =
news:C2DB2B96-5713-4EF3-A4B3-AC9F553ED07A@.microsoft.com...
> SQL Server 2000 SP3a. Just noticed that the stored procedures that =
were in the model database are gone. So any new databases will not =
contain these stored procedures. Is this a problem?
>=20
> Thanks,
>=20
> Warren|||Dear Keith,
The only SP's in the model database are the ones that come with the SQL Serv
er installation.. So your advice is to re-create them?
Thanks,
Chris Tyler
"Keith Kratochvil" wrote:

> We cannot answer that question for you. That is a question that you must
answer.
> If stored procedures were placed within the model database I would expect
that something or someone expects those stored procedures to be available in
the user databases that are created.
> It is easy enough to create the stored procedures...simply grab the scrip
ts and execute them in each database...then add them to model so that they w
ill exist within new databases as they are created.
> --
> Keith
>
> "Warren" <Warren@.discussions.microsoft.com> wrote in message news:C2DB2B96
-5713-4EF3-A4B3-AC9F553ED07A@.microsoft.com...
>|||Hmmm...I did not think that any (Microsoft supplied) stored procedures =
were stored within model. Which stored procedures are missing? (what =
are their names?)
--=20
Keith
"Warren" <Warren@.discussions.microsoft.com> wrote in message =
news:C588718C-438E-4801-9A14-513120C5FBDE@.microsoft.com...
> Dear Keith,
>=20
> The only SP's in the model database are the ones that come with the =
SQL Server installation.. So your advice is to re-create them?[vbcol=seagreen]
>=20
> Thanks,
>=20
> Chris Tyler
>=20
>=20
>=20
> "Keith Kratochvil" wrote:
>=20
must answer. =20[vbcol=seagreen]
expect that something or someone expects those stored procedures to be =
available in the user databases that are created. =20[vbcol=seagreen]
scripts and execute them in each database...then add them to model so =
that they will exist within new databases as they are created.[vbcol=seagreen]
news:C2DB2B96-5713-4EF3-A4B3-AC9F553ED07A@.microsoft.com...[vbcol=seagreen]
that were in the model database are gone. So any new databases will not =
contain these stored procedures. Is this a problem?[vbcol=seagreen]|||> The only SP's in the model database are the ones that come with the SQL
Server installation.
There are no such things, in any of my installations here. Can you name a
few of these "missing" stored procedures?|||Hi Aaron,
There may not be any System SP's in the Model database.. What I find is most
server have no SP's within Model, but some have dt_Stored procedures that s
ay System. For example, dt_addsourcecontrol, dt_addsourcecontrol_u, dt_addu
serobject...So this may hav
e come into Model by other means...
Thanks,
Warren
"Aaron [SQL Server MVP]" wrote:

> Server installation.
> There are no such things, in any of my installations here. Can you name a
> few of these "missing" stored procedures?
>
>|||These are created automatically if you click on the diagram node in a
database. They don't need to exist, if they are missing, they will be
created by SQL Server. Not quite sure how they get into model (I think a few
other things trigger their creation as well) as there shouldn't be a diagram
node in EM for system databases.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Warren" <Warren@.discussions.microsoft.com> wrote in message
news:BC201722-6FE3-41BD-A22A-FAB84D3FEE37@.microsoft.com...
> Hi Aaron,
> There may not be any System SP's in the Model database.. What I find is
most server have no SP's within Model, but some have dt_Stored procedures
that say System. For example, dt_addsourcecontrol, dt_addsourcecontrol_u,
dt_adduserobject...So this may have come into Model by other means...[vbcol=seagreen]
> Thanks,
> Warren
> "Aaron [SQL Server MVP]" wrote:
>
SQL[vbcol=seagreen]
a[vbcol=seagreen]