CopyAllFunctions Property

SQL-DMO

SQL-DMO

CopyAllFunctions Property

The CopyAllFunctions property controls the transfer of Microsoft® SQL Server™ user-defined functions from the source to the target database.

Applies To
Transfer2 Object
Syntax

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

HRESULT SetCopyAllFunctions(BOOL NewValue);

Remarks

If TRUE, all SQL Server user-defined functions in the source database are copied to the target.

If FALSE, only user-defined functions specified by the AddObject and AddObjectByName methods are copied.

Note  If an application calls CopyAllFunctions on an instance of SQL Server version 7.0, the operation is ignored.