SQL Server Copy Object Task: include dependent objects 
Author Message
 SQL Server Copy Object Task: include dependent objects

Hello,

I 'd like to know what the "include all dependent objects" Checkbox in this task exactly means.
(I hope the literal description can be understood because I 've got a german SQL Server.)

What kind of relations of Table/View/Stored Procedures does this Option include?

I found that,
- If a View relates to a Table, the Table is copied too.
- If a View relates to another View, the other view is NOT copied (but isn't this a relation ?)

a) Is this correct?

b) Are there any other relations between Objects which come into question with this option?

c) In addition, I found that, if you specify a path for scripts, the task creates a set of pretty good files, in which the actions and errors are
described (id1, id2, def, dp1, viw, usr....). Is the meaning of this set described in detail somewhere, to understand them fully?

(SQL Server 2000)

Thank You very much

Joachim



Tue, 27 Sep 2005 01:36:44 GMT
 SQL Server Copy Object Task: include dependent objects

a) The information that is used for determining what the dependencies are is
stored in the sysdepends table. Unfortunately the information is not always
correct, as it is not updated for the referencing objects when you drop and
recreate (as opposed to alter)an object.
b) everything really, copying a table with "include all dependent objects"
will copy over the user defined data types, defaults and rules it relies on,
copying a stored procedure in this way will copy the tables and views and
other stored procedures it references etc. (all dependent on the problem
described under a) of course)
c) don't know anything about that

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


Quote:
> Hello,

> I 'd like to know what the "include all dependent objects" Checkbox in

this task exactly means.
Quote:
> (I hope the literal description can be understood because I 've got a
german SQL Server.)

> What kind of relations of Table/View/Stored Procedures does this Option
include?

> I found that,
> - If a View relates to a Table, the Table is copied too.
> - If a View relates to another View, the other view is NOT copied (but

isn't this a relation ?)
Quote:

> a) Is this correct?

> b) Are there any other relations between Objects which come into question
with this option?

> c) In addition, I found that, if you specify a path for scripts, the task

creates a set of pretty good files, in which the actions and errors are
Quote:
> described (id1, id2, def, dp1, viw, usr....). Is the meaning of this set

described in detail somewhere, to understand them fully?
Quote:

> (SQL Server 2000)

> Thank You very much

> Joachim



Tue, 27 Sep 2005 20:25:53 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Copy SQL Server Objects Task: Error 80045707 and Some Objects Not Copied

2. Dependent objects script is empty although many dependent objects exist

3. Copy SQL Server Objects Task

4. Copy SQL Server Objects Task Question

5. Copy SQL Server Objects task hangs on scheduled DTS run

6. DTS failing with copy sql server objects task.

7. DTS Copy SQL Server Objects Task Truncating tables

8. Copy SQL Server Objects Task and DTS question

9. Problem with Copy SQL Server Objects Task

10. DTS Copy SQL Server Objects Task needs db_owner role

11. Rename Table After Copy SQL Server Object Task

12. copy SQL server object task truncates bigint fields


 
Powered by phpBB® Forum Software