The dt stored procedures are not getting copied when I use
the Copy SQL Server Objects task to copy a DB from a
server to an instance of the same server. Everything else
are been copied fine. Any idea? Thank you.

These are system stored procedures and system stored procedures do not get
copied by DTS.

Rand
This posting is provided "as is" with no warranties and confers no rights.

So how do I copy them. The DBs must have them to work,
right?

If you create a New DB then you have no dt* procs in the Db

In the new DB
Create a table using QA - No dt* procs
Create a table now using the Gui (EM). - dt* procs appear

As Rand mentions, when they are created a stored proc runs and marks them as
system objects. This can be seen using Profiler.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Olivia" <anonymous (AT) discussions (DOT) microsoft.com> wrote