CopyAllDefaults Property

SQL-DMO

SQL-DMO

CopyAllDefaults Property

The CopyAllDefaults property controls the transfer of Microsoft® SQL Server™ defaults from the source to the target database.

Applies To
Transfer Object
Syntax

object.CopyAllDefaults [= 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 GetCopyAllDefaults(LPBOOL pRetVal);

HRESULT SetCopyAllDefaults(BOOL NewValue);

Remarks

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

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

See Also

AddObject Method

AddObjectByName Method