Device Object Properties Methods Lists Collections
| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| Default Boolean Write: Yes |
Determines if unused space on this database device should be included in the default device pool. When the user creates a new database or extends an existing database, and either does not specify a database device or specifies the default database device, SQL Server uses available device space from the default device pool for database storage. If True, unused space on this device is included in the default device pool. If False, either this device is not included in the default device pool, or this is a dump device. |
| DeviceNumber Long Write: No |
The virtual device number. |
| FirstPage Long Write: No |
The first virtual page number. This property is -1 for dump devices. |
| LastPage Long Write: No |
The last virtual page number. This property is -1 for dump devices. |
| MirrorName String Write: No |
The full path and filename of the mirror device, if any. |
| MirrorState SQLOLE_MIRROR_TYPE Write: No |
The mirror state. |
| Name Identifier Write: Yes |
The name of this device. |
| Parent SQLServer Write: No |
The SQLServer object. |
| PhysicalLocation String Write: Before Add |
The full path and filename of the device storage space. |
| Size Long Write: Before Add |
The size of this device in megabytes. |
| SkipTapeLabel Boolean Write: Yes |
Determines if ANSI tape labels are ignored for dump devices. If True, ANSI tape labels are ignored. If False, either ANSI tape labels are read for dump devices, or this is a database device. |
| SpaceAvailable Long Write: No |
Unused space in megabytes. |
| Status Long Write: |
The status bitmap. |
| SystemObject Boolean Write: No |
Indicates if this is a SQL Server system device. If True, this is a SQL Server system device. If False, this device was created by a user. |
| Type SQLOLE_DEVICE_TYPE Write: Yes |
The type of the database or dump device. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |