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.