OTL 4.0, Example 689 (MS SQL Server 2005/2008 DBCC command)

This example demonstrates how to use the MS SQL Server DBCC command with OTL. DBCC command returns right away (after SQLExecDirect() call). Calls to SQLGetDiagRec()  need to be made in order to get the DBCC command's output diagnostic records.

Source Code

#include <iostream>
using namespace std;

#include <stdio.h>

// function that recognizes BACKUP and DBCC commands, and returns "true".
inline bool sql_statement_with_diag_rec_output(const char* stm_text)
{
if(strncmp(stm_text,"BACKUP",6)==0)
return true;
else if(strncmp(stm_text,"DBCC",4)==0)
return true;
else
return false;
}

// #define OTL_ODBC_MSSQL_2005 // Compile OTL 4/ODBC, MS SQL 2005
#define OTL_ODBC_MSSQL_2008 // Compile OTL 4/ODBC, MS SQL 2008
#define OTL_ODBC_SQL_STATEMENT_WITH_DIAG_REC_OUTPUT sql_statement_with_diag_rec_output

#include <otlv4.h> // include the OTL 4.0 header file

otl_connect db; // connect object
int main()
{
 otl_connect::otl_initialize(); // initialize the environment
 try{

  db.rlogon("scott/tiger@mssql2008",1);
// connect to the database in the "auto-commit" mode
// in order to avoid generating transactions.

// switch to the "master" database
db.direct_exec("USE master");

otl_nocommit_stream stm;
// the OTL "nocommit" stream doesn't generate any COMMITs,
// which is needed for the DBCC command.

short int rec_ndx=1; // diagnostic record index
SQLCHAR sql_state[1000]; // "SQL state" buffer
SQLCHAR msg[SQL_MAX_MESSAGE_LENGTH+1]; // diagnostic record / message buffer
int native_error; // native error code

const char* cmd = "DBCC CHECKALLOC";

stm.open(1,cmd,db);
// the stream recognizes the command as an "SQL statement
// with diagnostic record output" with the help of
// the sql_statement_with_diag_rec_output() function.
// the stream executes the statement right away with an
// SQLExecDirect() function call.

bool done;
// get all diagnostic records from the DBCC command
do{
done=stm.get_next_diag_rec
(rec_ndx,
sql_state,
msg,
sizeof(msg),
native_error);
cout<<msg<<endl;
}while(!done);
stm.close();

 }

 catch(otl_exception& p){ // intercept OTL exceptions
  cerr<<p.msg<<endl; // print out error message
  cerr<<p.sqlstate<<endl; // print out SQLSTATE 
  cerr<<p.stm_text<<endl; // print out SQL that caused the error
  cerr<<p.var_info<<endl; // print out the variable that caused the error
 }

 db.logoff(); // disconnect from the database

 return 0;

}

Output

[Microsoft][SQL Server Native Client 10.0][SQL Server]DBCC results for 'master'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysrscols Object ID 3.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 196608, alloc unit ID 196608 (type In-row data). FirstIAM (1:69). Root (1:58). Dpages 11.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 196608, alloc unit ID 196608 (type In-row data). 13 pages used in 1 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysrowsets Object ID 5.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 327680, alloc unit ID 327680 (type In-row data). FirstIAM (1:194). Root (1:18). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 327680, alloc unit ID 327680 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysallocunits Object ID 7.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data). FirstIAM (1:17). Root (1:359). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data). 5 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949953880064, alloc unit ID 562949953880064 (type In-row data). FirstIAM (1:64). Root (1:65). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949953880064, alloc unit ID 562949953880064 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysfiles1 Object ID 8.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data). FirstIAM (1:13). Root (1:32). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syspriorities Object ID 17.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977824768, alloc unit ID 281474977824768 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977824768, alloc unit ID 281474977824768 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949954535424, alloc unit ID 562949954535424 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949954535424, alloc unit ID 562949954535424 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931246080, alloc unit ID 844424931246080 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931246080, alloc unit ID 844424931246080 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysdbfrag Object ID 18.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977890304, alloc unit ID 281474977890304 (type In-row data). FirstIAM (1:82). Root (1:384). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977890304, alloc unit ID 281474977890304 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949954600960, alloc unit ID 562949954600960 (type In-row data). FirstIAM (1:80). Root (1:81). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949954600960, alloc unit ID 562949954600960 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysfgfrag Object ID 19.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977955840, alloc unit ID 281474977955840 (type In-row data). FirstIAM (1:76). Root (1:77). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474977955840, alloc unit ID 281474977955840 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syspru Object ID 21.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978086912, alloc unit ID 281474978086912 (type In-row data). FirstIAM (1:78). Root (1:79). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978086912, alloc unit ID 281474978086912 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysbrickfiles Object ID 22.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978152448, alloc unit ID 281474978152448 (type In-row data). FirstIAM (1:70). Root (1:71). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978152448, alloc unit ID 281474978152448 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysphfg Object ID 23.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978217984, alloc unit ID 281474978217984 (type In-row data). FirstIAM (1:74). Root (1:75). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978217984, alloc unit ID 281474978217984 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysprufiles Object ID 24.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978283520, alloc unit ID 281474978283520 (type In-row data). FirstIAM (1:72). Root (1:73). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978283520, alloc unit ID 281474978283520 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysftinds Object ID 25.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978349056, alloc unit ID 281474978349056 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978349056, alloc unit ID 281474978349056 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysowners Object ID 27.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978480128, alloc unit ID 281474978480128 (type In-row data). FirstIAM (1:363). Root (1:364). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978480128, alloc unit ID 281474978480128 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data). FirstIAM (1:179). Root (1:178). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931901440, alloc unit ID 844424931901440 (type In-row data). FirstIAM (1:335). Root (1:360). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931901440, alloc unit ID 844424931901440 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysdbreg Object ID 28.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978545664, alloc unit ID 281474978545664 (type In-row data). FirstIAM (1:374). Root (1:375). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978545664, alloc unit ID 281474978545664 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955256320, alloc unit ID 562949955256320 (type In-row data). FirstIAM (1:181). Root (1:180). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955256320, alloc unit ID 562949955256320 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931966976, alloc unit ID 844424931966976 (type In-row data). FirstIAM (1:370). Root (1:371). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424931966976, alloc unit ID 844424931966976 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysprivs Object ID 29.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978611200, alloc unit ID 281474978611200 (type In-row data). FirstIAM (1:330). Root (1:326). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978611200, alloc unit ID 281474978611200 (type In-row data). 17 pages used in 1 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysschobjs Object ID 34.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). FirstIAM (1:293). Root (1:286). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data). 5 pages used in 1 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data). FirstIAM (1:183). Root (1:182). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data). FirstIAM (1:185). Root (1:184). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 4, partition ID 1125899909070848, alloc unit ID 1125899909070848 (type In-row data). FirstIAM (1:289). Root (1:290). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 4, partition ID 1125899909070848, alloc unit ID 1125899909070848 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syslogshippers Object ID 39.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979266560, alloc unit ID 281474979266560 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979266560, alloc unit ID 281474979266560 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syscolpars Object ID 41.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). FirstIAM (1:316). Root (1:314). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). 16 pages used in 2 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956108288, alloc unit ID 562949956108288 (type In-row data). FirstIAM (1:187). Root (1:189). Dpages 3.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956108288, alloc unit ID 562949956108288 (type In-row data). 5 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxlgns Object ID 42.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979463168, alloc unit ID 281474979463168 (type In-row data). FirstIAM (1:321). Root (1:322). Dpages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979463168, alloc unit ID 281474979463168 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956173824, alloc unit ID 562949956173824 (type In-row data). FirstIAM (1:201). Root (1:200). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956173824, alloc unit ID 562949956173824 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424932884480, alloc unit ID 844424932884480 (type In-row data). FirstIAM (1:317). Root (1:318). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424932884480, alloc unit ID 844424932884480 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxsrvs Object ID 43.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979528704, alloc unit ID 281474979528704 (type In-row data). FirstIAM (1:478). Root (1:477). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979528704, alloc unit ID 281474979528704 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956239360, alloc unit ID 562949956239360 (type In-row data). FirstIAM (1:8). Root (1:479). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956239360, alloc unit ID 562949956239360 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysnsobjs Object ID 44.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979594240, alloc unit ID 281474979594240 (type In-row data). FirstIAM (1:105). Root (1:106). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979594240, alloc unit ID 281474979594240 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956304896, alloc unit ID 562949956304896 (type In-row data). FirstIAM (1:203). Root (1:202). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956304896, alloc unit ID 562949956304896 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysusermsgs Object ID 45.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979659776, alloc unit ID 281474979659776 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979659776, alloc unit ID 281474979659776 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syscerts Object ID 46.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979725312, alloc unit ID 281474979725312 (type In-row data). FirstIAM (1:409). Root (1:408). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979725312, alloc unit ID 281474979725312 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979725312, alloc unit ID 72057594038059008 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979725312, alloc unit ID 72057594038059008 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956435968, alloc unit ID 562949956435968 (type In-row data). FirstIAM (1:205). Root (1:204). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956435968, alloc unit ID 562949956435968 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424933146624, alloc unit ID 844424933146624 (type In-row data). FirstIAM (1:413). Root (1:412). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424933146624, alloc unit ID 844424933146624 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 4, partition ID 1125899909857280, alloc unit ID 1125899909857280 (type In-row data). FirstIAM (1:415). Root (1:414). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 4, partition ID 1125899909857280, alloc unit ID 1125899909857280 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysrmtlgns Object ID 47.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979790848, alloc unit ID 72057594039894016 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979790848, alloc unit ID 72057594039894016 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syslnklgns Object ID 48.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979856384, alloc unit ID 281474979856384 (type In-row data). FirstIAM (1:162). Root (1:11). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979856384, alloc unit ID 281474979856384 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxprops Object ID 49.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979921920, alloc unit ID 72057594039959552 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979921920, alloc unit ID 72057594039959552 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysscalartypes Object ID 50.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979987456, alloc unit ID 281474979987456 (type In-row data). FirstIAM (1:382). Root (1:383). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474979987456, alloc unit ID 281474979987456 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956698112, alloc unit ID 562949956698112 (type In-row data). FirstIAM (1:207). Root (1:206). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956698112, alloc unit ID 562949956698112 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424933408768, alloc unit ID 844424933408768 (type In-row data). FirstIAM (1:241). Root (1:240). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424933408768, alloc unit ID 844424933408768 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.systypedsubobjs Object ID 51.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980052992, alloc unit ID 281474980052992 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980052992, alloc unit ID 281474980052992 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956763648, alloc unit ID 562949956763648 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956763648, alloc unit ID 562949956763648 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysidxstats Object ID 54.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980249600, alloc unit ID 281474980249600 (type In-row data). FirstIAM (1:198). Root (1:163). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980249600, alloc unit ID 281474980249600 (type In-row data). 4 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956960256, alloc unit ID 562949956960256 (type In-row data). FirstIAM (1:243). Root (1:242). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949956960256, alloc unit ID 562949956960256 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysiscols Object ID 55.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (type In-row data). FirstIAM (1:127). Root (1:385). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (type In-row data). 5 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957025792, alloc unit ID 562949957025792 (type In-row data). FirstIAM (1:23). Root (1:22). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957025792, alloc unit ID 562949957025792 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysendpts Object ID 56.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980380672, alloc unit ID 281474980380672 (type In-row data). FirstIAM (1:389). Root (1:393). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980380672, alloc unit ID 281474980380672 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957091328, alloc unit ID 562949957091328 (type In-row data). FirstIAM (1:245). Root (1:244). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957091328, alloc unit ID 562949957091328 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syswebmethods Object ID 57.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980446208, alloc unit ID 281474980446208 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980446208, alloc unit ID 281474980446208 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysbinobjs Object ID 58.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980511744, alloc unit ID 281474980511744 (type In-row data). FirstIAM (1:355). Root (1:354). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980511744, alloc unit ID 281474980511744 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957222400, alloc unit ID 562949957222400 (type In-row data). FirstIAM (1:357). Root (1:356). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957222400, alloc unit ID 562949957222400 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysaudacts Object ID 59.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980577280, alloc unit ID 281474980577280 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980577280, alloc unit ID 281474980577280 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysobjvalues Object ID 60.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). FirstIAM (1:369). Root (1:288). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). 40 pages used in 7 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). FirstIAM (1:287). Root (1:764). Dpages 4.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). 4 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 7.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysclsobjs Object ID 64.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data). FirstIAM (1:367). Root (1:368). Dpages 7.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957615616, alloc unit ID 562949957615616 (type In-row data). FirstIAM (1:247). Root (1:246). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957615616, alloc unit ID 562949957615616 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysrowsetrefs Object ID 65.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980970496, alloc unit ID 281474980970496 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474980970496, alloc unit ID 281474980970496 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysremsvcbinds Object ID 67.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981101568, alloc unit ID 281474981101568 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981101568, alloc unit ID 281474981101568 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957812224, alloc unit ID 562949957812224 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957812224, alloc unit ID 562949957812224 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424934522880, alloc unit ID 844424934522880 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424934522880, alloc unit ID 844424934522880 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxmitqueue Object ID 68.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981167104, alloc unit ID 281474981167104 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981167104, alloc unit ID 281474981167104 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981167104, alloc unit ID 72057594037927936 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981167104, alloc unit ID 72057594037927936 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysrts Object ID 69.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981232640, alloc unit ID 281474981232640 (type In-row data). FirstIAM (1:467). Root (1:466). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981232640, alloc unit ID 281474981232640 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957943296, alloc unit ID 562949957943296 (type In-row data). FirstIAM (1:469). Root (1:468). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949957943296, alloc unit ID 562949957943296 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424934653952, alloc unit ID 844424934653952 (type In-row data). FirstIAM (1:337). Root (1:336). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424934653952, alloc unit ID 844424934653952 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysconvgroup Object ID 71.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981363712, alloc unit ID 281474981363712 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981363712, alloc unit ID 281474981363712 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysdesend Object ID 72.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981429248, alloc unit ID 281474981429248 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981429248, alloc unit ID 281474981429248 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysdercv Object ID 73.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981494784, alloc unit ID 281474981494784 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981494784, alloc unit ID 281474981494784 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syssingleobjrefs Object ID 74.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981560320, alloc unit ID 281474981560320 (type In-row data). FirstIAM (1:333). Root (1:334). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981560320, alloc unit ID 281474981560320 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958270976, alloc unit ID 562949958270976 (type In-row data). FirstIAM (1:331). Root (1:332). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958270976, alloc unit ID 562949958270976 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysmultiobjrefs Object ID 75.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981625856, alloc unit ID 281474981625856 (type In-row data). FirstIAM (1:329). Root (1:312). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981625856, alloc unit ID 281474981625856 (type In-row data). 3 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958336512, alloc unit ID 562949958336512 (type In-row data). FirstIAM (1:327). Root (1:328). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958336512, alloc unit ID 562949958336512 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysguidrefs Object ID 78.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981822464, alloc unit ID 281474981822464 (type In-row data). FirstIAM (1:175). Root (1:174). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981822464, alloc unit ID 281474981822464 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958533120, alloc unit ID 562949958533120 (type In-row data). FirstIAM (1:177). Root (1:176). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949958533120, alloc unit ID 562949958533120 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syschildinsts Object ID 80.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981953536, alloc unit ID 281474981953536 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474981953536, alloc unit ID 281474981953536 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syscompfragments Object ID 82.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982084608, alloc unit ID 281474982084608 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982084608, alloc unit ID 281474982084608 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysftstops Object ID 85.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982281216, alloc unit ID 281474982281216 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982281216, alloc unit ID 281474982281216 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysqnames Object ID 90.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982608896, alloc unit ID 281474982608896 (type In-row data). FirstIAM (1:109). Root (1:110). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982608896, alloc unit ID 281474982608896 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959319552, alloc unit ID 562949959319552 (type In-row data). FirstIAM (1:107). Root (1:108). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959319552, alloc unit ID 562949959319552 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxmlcomponent Object ID 91.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982674432, alloc unit ID 281474982674432 (type In-row data). FirstIAM (1:14). Root (1:12). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982674432, alloc unit ID 281474982674432 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959385088, alloc unit ID 562949959385088 (type In-row data). FirstIAM (1:33). Root (1:15). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959385088, alloc unit ID 562949959385088 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxmlfacet Object ID 92.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982739968, alloc unit ID 281474982739968 (type In-row data). FirstIAM (1:35). Root (1:34). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982739968, alloc unit ID 281474982739968 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysxmlplacement Object ID 93.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982805504, alloc unit ID 281474982805504 (type In-row data). FirstIAM (1:37). Root (1:36). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982805504, alloc unit ID 281474982805504 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959516160, alloc unit ID 562949959516160 (type In-row data). FirstIAM (1:39). Root (1:38). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959516160, alloc unit ID 562949959516160 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysobjkeycrypts Object ID 94.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982871040, alloc unit ID 281474982871040 (type In-row data). FirstIAM (1:172). Root (1:171). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982871040, alloc unit ID 281474982871040 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982871040, alloc unit ID 72057594037993472 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982871040, alloc unit ID 72057594037993472 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysasymkeys Object ID 95.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982936576, alloc unit ID 281474982936576 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982936576, alloc unit ID 281474982936576 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982936576, alloc unit ID 72057594038124544 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474982936576, alloc unit ID 72057594038124544 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959647232, alloc unit ID 562949959647232 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959647232, alloc unit ID 562949959647232 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424936357888, alloc unit ID 844424936357888 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424936357888, alloc unit ID 844424936357888 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syssqlguides Object ID 96.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983002112, alloc unit ID 281474983002112 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983002112, alloc unit ID 281474983002112 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983002112, alloc unit ID 72057594039107584 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983002112, alloc unit ID 72057594039107584 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959712768, alloc unit ID 562949959712768 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959712768, alloc unit ID 562949959712768 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424936423424, alloc unit ID 844424936423424 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 3, partition ID 844424936423424, alloc unit ID 844424936423424 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.sysbinsubobjs Object ID 97.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983067648, alloc unit ID 281474983067648 (type In-row data). FirstIAM (1:126). Root (1:195). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983067648, alloc unit ID 281474983067648 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959778304, alloc unit ID 562949959778304 (type In-row data). FirstIAM (1:124). Root (1:125). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959778304, alloc unit ID 562949959778304 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syssoftobjrefs Object ID 98.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983133184, alloc unit ID 72057594040025088 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 281474983133184, alloc unit ID 72057594040025088 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959843840, alloc unit ID 562949959843840 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 562949959843840, alloc unit ID 562949959843840 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table spt_fallback_db Object ID 117575457.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 7705425149952, alloc unit ID 7705425149952 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 1.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 7705425149952, alloc unit ID 7705425149952 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table spt_fallback_dev Object ID 133575514.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 8754004885504, alloc unit ID 8754004885504 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 8754004885504, alloc unit ID 8754004885504 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table spt_fallback_usg Object ID 149575571.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 9802584621056, alloc unit ID 9802584621056 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 9802584621056, alloc unit ID 9802584621056 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.queue_messages_1003150619 Object ID 1019150676.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594038321152 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594038321152 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594039173120 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594039173120 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594039238656 (type Row-overflow data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038452224, alloc unit ID 72057594039238656 (type Row-overflow data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594037993472, alloc unit ID 72057594038386688 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594037993472, alloc unit ID 72057594038386688 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.queue_messages_1035150733 Object ID 1051150790.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594038583296 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594038583296 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594039304192 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594039304192 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594039369728 (type Row-overflow data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038517760, alloc unit ID 72057594039369728 (type Row-overflow data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038124544, alloc unit ID 72057594038648832 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038124544, alloc unit ID 72057594038648832 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.queue_messages_1067150847 Object ID 1083150904.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594038845440 (type LOB data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594038845440 (type LOB data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594039435264 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594039435264 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594039500800 (type Row-overflow data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038583296, alloc unit ID 72057594039500800 (type Row-overflow data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038255616, alloc unit ID 72057594038910976 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038255616, alloc unit ID 72057594038910976 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table sys.syscommittab Object ID 1099150961.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038321152, alloc unit ID 72057594038976512 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038321152, alloc unit ID 72057594038976512 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038386688, alloc unit ID 72057594039042048 (type In-row data). FirstIAM (0:0). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594038386688, alloc unit ID 72057594039042048 (type In-row data). 0 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table spt_monitor Object ID 1115151018.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 72057594038648832, alloc unit ID 72057594039566336 (type In-row data). FirstIAM (1:471). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 72057594038648832, alloc unit ID 72057594039566336 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table spt_values Object ID 1131151075.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038976512, alloc unit ID 72057594040090624 (type In-row data). FirstIAM (1:339). Root (1:341). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 1, partition ID 72057594038976512, alloc unit ID 72057594040090624 (type In-row data). 14 pages used in 1 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594039042048, alloc unit ID 72057594040156160 (type In-row data). FirstIAM (1:348). Root (1:350). Dpages 7.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 2, partition ID 72057594039042048, alloc unit ID 72057594040156160 (type In-row data). 9 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]***************************************************************
[Microsoft][SQL Server Native Client 10.0][SQL Server]Table MSreplication_options Object ID 1163151189.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039828480 (type In-row data). FirstIAM (1:170). Root (0:0). Dpages 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039828480 (type In-row data). 2 pages used in 0 dedicated extents.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Total number of extents is 0.
[Microsoft][SQL Server Native Client 10.0][SQL Server]File 1. The number of extents = 47, used pages = 272, and reserved pages = 318.
[Microsoft][SQL Server Native Client 10.0][SQL Server] File 1 (number of mixed extents = 33, mixed pages = 206).
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 3, index ID 1, partition ID 196608, alloc unit ID 196608 (type In-row data), data extents 1, pages 13, mixed extent pages 8.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 5, index ID 1, partition ID 327680, alloc unit ID 327680 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 7, index ID 1, partition ID 458752, alloc unit ID 458752 (type In-row data), data extents 0, pages 5, mixed extent pages 5.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 7, index ID 2, partition ID 562949953880064, alloc unit ID 562949953880064 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 8, index ID 0, partition ID 524288, alloc unit ID 524288 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 18, index ID 1, partition ID 281474977890304, alloc unit ID 281474977890304 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 18, index ID 2, partition ID 562949954600960, alloc unit ID 562949954600960 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 19, index ID 1, partition ID 281474977955840, alloc unit ID 281474977955840 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 21, index ID 1, partition ID 281474978086912, alloc unit ID 281474978086912 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 22, index ID 1, partition ID 281474978152448, alloc unit ID 281474978152448 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 23, index ID 1, partition ID 281474978217984, alloc unit ID 281474978217984 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 24, index ID 1, partition ID 281474978283520, alloc unit ID 281474978283520 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 27, index ID 1, partition ID 281474978480128, alloc unit ID 281474978480128 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 27, index ID 2, partition ID 562949955190784, alloc unit ID 562949955190784 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 27, index ID 3, partition ID 844424931901440, alloc unit ID 844424931901440 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 28, index ID 1, partition ID 281474978545664, alloc unit ID 281474978545664 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 28, index ID 2, partition ID 562949955256320, alloc unit ID 562949955256320 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 28, index ID 3, partition ID 844424931966976, alloc unit ID 844424931966976 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 29, index ID 1, partition ID 281474978611200, alloc unit ID 281474978611200 (type In-row data), data extents 1, pages 17, mixed extent pages 9.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type In-row data), data extents 1, pages 5, mixed extent pages 4.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 34, index ID 2, partition ID 562949955649536, alloc unit ID 562949955649536 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 34, index ID 3, partition ID 844424932360192, alloc unit ID 844424932360192 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 34, index ID 4, partition ID 1125899909070848, alloc unit ID 1125899909070848 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data), data extents 2, pages 16, mixed extent pages 6.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 41, index ID 2, partition ID 562949956108288, alloc unit ID 562949956108288 (type In-row data), index extents 0, pages 5, mixed extent pages 5.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 42, index ID 1, partition ID 281474979463168, alloc unit ID 281474979463168 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 42, index ID 2, partition ID 562949956173824, alloc unit ID 562949956173824 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 42, index ID 3, partition ID 844424932884480, alloc unit ID 844424932884480 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 43, index ID 1, partition ID 281474979528704, alloc unit ID 281474979528704 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 43, index ID 2, partition ID 562949956239360, alloc unit ID 562949956239360 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 44, index ID 1, partition ID 281474979594240, alloc unit ID 281474979594240 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 44, index ID 2, partition ID 562949956304896, alloc unit ID 562949956304896 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 46, index ID 1, partition ID 281474979725312, alloc unit ID 281474979725312 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 46, index ID 2, partition ID 562949956435968, alloc unit ID 562949956435968 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 46, index ID 3, partition ID 844424933146624, alloc unit ID 844424933146624 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 46, index ID 4, partition ID 1125899909857280, alloc unit ID 1125899909857280 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 48, index ID 1, partition ID 281474979856384, alloc unit ID 281474979856384 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 50, index ID 1, partition ID 281474979987456, alloc unit ID 281474979987456 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 50, index ID 2, partition ID 562949956698112, alloc unit ID 562949956698112 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 50, index ID 3, partition ID 844424933408768, alloc unit ID 844424933408768 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 54, index ID 1, partition ID 281474980249600, alloc unit ID 281474980249600 (type In-row data), data extents 0, pages 4, mixed extent pages 4.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 54, index ID 2, partition ID 562949956960256, alloc unit ID 562949956960256 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 55, index ID 1, partition ID 281474980315136, alloc unit ID 281474980315136 (type In-row data), data extents 0, pages 5, mixed extent pages 5.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 55, index ID 2, partition ID 562949957025792, alloc unit ID 562949957025792 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 56, index ID 1, partition ID 281474980380672, alloc unit ID 281474980380672 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 56, index ID 2, partition ID 562949957091328, alloc unit ID 562949957091328 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 58, index ID 1, partition ID 281474980511744, alloc unit ID 281474980511744 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 58, index ID 2, partition ID 562949957222400, alloc unit ID 562949957222400 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data), index extents 0, pages 4, mixed extent pages 4.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), data extents 7, pages 40, mixed extent pages 9.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 64, index ID 1, partition ID 281474980904960, alloc unit ID 281474980904960 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 64, index ID 2, partition ID 562949957615616, alloc unit ID 562949957615616 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 69, index ID 1, partition ID 281474981232640, alloc unit ID 281474981232640 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 69, index ID 2, partition ID 562949957943296, alloc unit ID 562949957943296 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 69, index ID 3, partition ID 844424934653952, alloc unit ID 844424934653952 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 74, index ID 1, partition ID 281474981560320, alloc unit ID 281474981560320 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 74, index ID 2, partition ID 562949958270976, alloc unit ID 562949958270976 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 75, index ID 1, partition ID 281474981625856, alloc unit ID 281474981625856 (type In-row data), data extents 0, pages 3, mixed extent pages 3.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 75, index ID 2, partition ID 562949958336512, alloc unit ID 562949958336512 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 78, index ID 1, partition ID 281474981822464, alloc unit ID 281474981822464 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 78, index ID 2, partition ID 562949958533120, alloc unit ID 562949958533120 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 90, index ID 1, partition ID 281474982608896, alloc unit ID 281474982608896 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 90, index ID 2, partition ID 562949959319552, alloc unit ID 562949959319552 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 91, index ID 1, partition ID 281474982674432, alloc unit ID 281474982674432 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 91, index ID 2, partition ID 562949959385088, alloc unit ID 562949959385088 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 92, index ID 1, partition ID 281474982739968, alloc unit ID 281474982739968 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 93, index ID 1, partition ID 281474982805504, alloc unit ID 281474982805504 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 93, index ID 2, partition ID 562949959516160, alloc unit ID 562949959516160 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 94, index ID 1, partition ID 281474982871040, alloc unit ID 281474982871040 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 97, index ID 1, partition ID 281474983067648, alloc unit ID 281474983067648 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 97, index ID 2, partition ID 562949959778304, alloc unit ID 562949959778304 (type In-row data), index extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 99, index ID 0, partition ID 0, alloc unit ID 6488064 (type System allocation data), index extents 1, pages 8, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 1115151018, index ID 0, partition ID 72057594038648832, alloc unit ID 72057594039566336 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 1131151075, index ID 1, partition ID 72057594038976512, alloc unit ID 72057594040090624 (type In-row data), data extents 1, pages 14, mixed extent pages 9.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 1131151075, index ID 2, partition ID 72057594039042048, alloc unit ID 72057594040156160 (type In-row data), index extents 0, pages 9, mixed extent pages 9.
[Microsoft][SQL Server Native Client 10.0][SQL Server] Object ID 1163151189, index ID 0, partition ID 72057594038910976, alloc unit ID 72057594039828480 (type In-row data), data extents 0, pages 2, mixed extent pages 2.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The total number of extents = 47, used pages = 272, and reserved pages = 318 in this database.
[Microsoft][SQL Server Native Client 10.0][SQL Server] (number of mixed extents = 33, mixed pages = 206) in this database.
[Microsoft][SQL Server Native Client 10.0][SQL Server]CHECKALLOC found 0 allocation errors and 0 consistency errors in database 'master'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.



Examples ContentsGo Home

Copyright © 1996-2023, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.com .

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies. THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.