Share via


VerifyEx Method (SQL Server Compact)

Recalculates the checksums for each page in the database and compares the new checksums to the expected values. Checks that each index entry exists in the table and that each table entry exists in the index. This option is slower and more thorough than the Verify Method (SQL Server Compact).

Syntax

HRESULT VerifyEx(BSTR SourceConnection)

Parameters

  • SourceConnection
    A string value specifying a connection to the source database to be verified.

Return Value

Return type is HRESULT, and S_OK is returned on success.

Remarks

If this method returns false, the database is corrupt, and your application must call the Repair Method (SQL Server Compact) to correct the problem.

Note

False is also returned if there is a failure connecting to the database. Scenarios include an incorrect password, or the database is already opened in exclusive mode by another application.

.NET Framework Equivalent

Verify

See Also

Other Resources

Engine Object Methods

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)