This topic has not yet been rated - Rate this topic

Database.CheckAllocationsDataOnly Method

SQL Server 2008

Scans all pages of the referenced database and tests only the data to help ensure integrity.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public StringCollection CheckAllocationsDataOnly()

Return Value

Type: System.Collections.Specialized.StringCollection
A StringCollection object value that contains a report about the allocations in the database.

Remarks

This method is equivalent to the DBCC CHECKALLOC Transact-SQL statement.

Examples

VBNET

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'Note, to use the StringCollection type the System.Collections.Specialized system namespace must be included in the imports statements.
Dim sc As StringCollection
'Run the CheckTables method and display the results from the returned StringCollection variable.
sc = db.CheckTables(RepairType.None)
Dim c As Integer
For c = 0 To sc.Count - 1
    Console.WriteLine(sc.Item(c))
Next

Reference

Database Class

Database Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

DBCC CHECKALLOC (Transact-SQL)

Creating, Altering, and Removing Databases

CREATE DATABASE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD