dbTalk Databases Forums  

dt SP not been copied

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss dt SP not been copied in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Olivia
 
Posts: n/a

Default dt SP not been copied - 02-12-2004 , 11:59 AM






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.

Reply With Quote
  #2  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: dt SP not been copied - 02-12-2004 , 12:20 PM






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.


Reply With Quote
  #3  
Old   
Olivia
 
Posts: n/a

Default RE: dt SP not been copied - 02-12-2004 , 01:02 PM



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

Quote:
-----Original Message-----
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.

.


Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: dt SP not been copied - 02-13-2004 , 02:02 AM



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

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

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

.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.