Syntax

object.PrimaryFile [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Remarks

A Microsoft® SQL Server™ 2000 database can have, at most, one primary file. When creating a database using SQL-DMO, the first DBFile object named PRIMARY added to the DBFiles collection of the FileGroup object referencing the filegroup becomes the primary file. Set the PrimaryFile property to alter the default behavior.

Data Type

Boolean

Modifiable

Read/write prior to database creation. Read-only after database creation.

Prototype (C/C++)

HRESULT GetPrimaryFile(LPBOOL pRetVal);

HRESULT SetPrimaryFile(BOOL NewValue);

Remarks

Running Transact-SQL scripts before an initial snapshot is applied can be used to:

• Perform pre-snapshot cleanup.
  
  
• Add users and permissions to databases to be replicated.
  
  
• Create user-defined data types.

  Note  If PreSnapshotScript is set, the script automatically runs when a subscription is reinitialized. Therefore, the script must be written so that its statements are repeatable.