Partilhar via

  • Artigo

CheckAllocations Method

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The CheckAllocations method scans all pages of the referenced database on Microsoft SQL Server 2000 and later, testing pages to ensure integrity.

Sintaxe

object
.CheckAllocations( [ RepairType ] )as String

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • RepairType
    Optional. A long integer that specifies database repair action as described in Settings.

Prototype (C/C++)

HRESULT CheckAllocations(SQLDMO_LPBSTR pResult,
SQLDMO_DBCC_REPAIR_TYPE lType = SQLDMORepair_None);
ObservaçãoObservação

SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Settings

Constant

Value

Description

SQLDMORepair_Allow_/DataLoss

3

Attempt all database repairs regardless of the possibility of data loss. For example, delete corrupted text objects.

SQLDMORepair_Fast

1

Attempt database repair tasks that do not incur data loss.

SQLDMORepair_None

0

Default. Do not attempt database repair on database inconsistencies encountered.

SQLDMORepair_Rebuild

2

Attempt database repair tasks that do not incur data loss. Rebuild indexes on successful database repair.

Returns

A string that contains error detail information.

Comentários

The database referenced by the SQL-DMO object must be in single-user mode when using the RepairType argument of the CheckAllocations method to perform database repair. To set single-user mode on a database using SQL-DMO, use the SingleUser property of the DBOption object.

The CheckAllocations method is implemented using the Transact-SQL DBCC CHECKALLOC statement. The return value of CheckAllocations is a string representation of the error messages returned by DBCC CHECKALLOC.

Applies to:

Database Object