Copy Objects Dependencies

I am trying to copy a "snapshot" of a remote sql server 2000 database to a
local sql server 2000 database. I just want to run a simple Copy Objects
dts, but it is choking on a user defined function.

Another object needs the udf but the udf hasn't been created. Is there any
straightforward way to fix dependency issues? I don't want to have to pick
specific objects to copy because it won't update if new objects are added.

Hello,

Based on my scope, It seems that recursive dependencies are not handled
correctly by the Copy Objects Task if there are potential circle
dependences. You may want to use backup/restore for this situation which is
more efficient.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
>Thread-Topic: Copy Objects Dependencies
>thread-index: AcYFlwXIDy7p+4UMSCCKJESNef7+FQ==
>X-WBNR-Posting-Host: 70.226.80.238
>From: =?Utf-8?B?SmVk?=
>Subject: Copy Objects Dependencies
>Date: Tue, 20 Dec 2005 10:56:02 -0800
>Lines: 9
>Message-ID:
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.dts
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.dts:62668
>X-Tomcat-NG: microsoft.public.sqlserver.dts
>
>I am trying to copy a "snapshot" of a remote sql server 2000 database to a
>local sql server 2000 database. I just want to run a simple Copy Objects
>dts, but it is choking on a user defined function.
>
>Another object needs the udf but the udf hasn't been created. Is there
any
>straightforward way to fix dependency issues? I don't want to have to
pick
>specific objects to copy because it won't update if new objects are added.
>
>
>