CopyAllObjects Property

SQL-DMO

CopyAllObjects Property

The CopyAllObjects property controls the transfer of Microsoft® SQL Server™ database objects from the source to the target database. SQL Server database objects are defaults, rules, stored procedures, tables, triggers, user-defined data types, and views.

Applies To

Transfer Object

Syntax

object.CopyAllObjects [= value]

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetCopyAllObjects(LPBOOL pRetVal);

HRESULT SetCopyAllObjects(BOOL NewValue);

Remarks

If TRUE, all SQL Server database objects in the source database are copied to the target.

If FALSE, only database objects indicated by the AddObject and AddObjectByName methods are copied.