• Article

CreateForAttach Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The CreateForAttach property controls database file creation when the Database object is added to the Databases collection of a connected SQLServer object.

Syntax

object.CreateForAttach [=value]

Parts

  • object
    An 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 GetCreateForAttach(LPBOOL pRetVal);
HRESULT SetCreateForAttach(BOOL NewValue);

Remarks

If TRUE, the database is created from files specified in the FileGroups and LogFiles collections.

If FALSE, data files are created as directed by the FileGroups and LogFiles collections.

Creating databases from existing data files is constrained. For more information, see CREATE DATABASE (Transact-SQL).

Note

CreateForAttach can only be set when the database is initially created.

Applies To:

Database Object