Table Corruption - DBCC Output
Dec 14, 2005
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1513928615, index ID 0: Page (3:33709) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1513928615, index ID 0, page (3:33709), row 0. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 95 and 30.
DBCC results for 'Result'.
There are 41589306 rows in 660667 pages for object 'Result'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'Result' (object ID 1513928615).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (LASAR2.dbo.Result ).
View 12 Replies
ADVERTISEMENT
Jun 22, 2006
I have had several database errors (reported in event log) on our main database this morning. I assume this is due to faulty hardware etc (that's 'usually' the case, right?). Anyway, I have a maintenance plan in place that runs the 'DBCC CHECKDB ([ourdatabase])' command. However, this command constantly reported no problems with the database (0 errors).
1) Is the 'DBCC CHECKDB' command 'comprehensive' enough to find ANY/ALL errors in databases?
2) How do you run a repair on a suspected corrupted DB? (I have tried the REBUILD_REPAIR command but it fails...saying something about incorrect syntax (as if it's not a recognised command in QA)
3) I currently use Veritas Backup Exec's 'SQL Agent' to backup our SQL DB - I also run a maintenance job (via EM) to backup the DB throughout the day)
4) I have never restored our database from the 'file' backup that is created via the maintenance plan - How is this done? Note: I have tried restoring our DB backup from Veritas and it works fine, would just like to know how to do it from the file backup that is created via our maintenance plan?
5) Once a DB is restored, how do you replay the latest transaction log files etc?..
Notes: We are running SQL Server 2000 Std Ed and our database is only around 250MB
Yes, I'm a complete noob:)
Many thanks
ras
View 12 Replies
View Related
Dec 17, 2007
All;
I have 14 errors in one of my tables and I know that all of you would recomend to restore form back-up. But i dont know when this table was corrupted and also loosing even days work is not an option.
Below is what i received from
DBCC CHECKDB ------
I dont mind loosing some data as far as i know what they are.
Any way to know what will be lost??
Or any other way to restore rather than form the backup....
===================================================================
DBCC results for 'Call_Events'.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341561), slot 21, text ID 120642207744 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341564), slot 53, text ID 120686379008 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 23, text ID 120684609536 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 27, text ID 120684806144 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341565), slot 28, text ID 120684937216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:341869), slot 0, text ID 120729305088 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342598), slot 45, text ID 120850743296 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:342677), slot 58, text ID 120895897600 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2073058421. The text, ntext, or image node at page (1:359535), slot 26, text ID 125433413632 is not referenced.
There are 1108430 rows in 91674 pages for object 'Call_Events'.
CHECKDB found 0 allocation errors and 14 consistency errors in table 'Call_Events' (object ID 2073058421).
View 3 Replies
View Related
Aug 19, 2001
I wrote a stored procedure that executes a dbcc sqlperf(logspace) statement many times. Therefore, I would like to suppress the output, "DBCC execution completed...". Can this be done? I have checked Books Online for a trace flag or set command to no avail.
View 1 Replies
View Related
Jan 29, 2001
I want to automate the dbcc checkdb process. I create a temp table called #CheckDbTbl and run the following command:
INSERT INTO #CheckDBTbl
dbcc checkdb(MyDbName) with tableresults
I plan to send myself an email if any problems are found.
Does anyone know what Error numbers or Levels or anything else I should look for in the #CheckDBTbl that will tell me a problem exists? Right now I'm only checking for: Level >= 16.
Many thanks for your responses!
-bh
View 1 Replies
View Related
Nov 10, 1998
When running the DBCC sqlperf (LRUSTATS) command I get
an extremely high value for the Avg Free Page Scan.
Typically, this value was between 1 and 2 for our
SQL 6.0 Server, but in upgrading to SQL 6.5, it has
jumped to about 200. Recently, I noticed another value
looks suspect. The Max Free Page Scan is equal to 1,
obviously not the *Max* value if the average is 200.
I know that others have seen this same behavior both
in this group and in the microsoft newsgroups. It seems
as though these values have been reversed or since
every example I've seen posted by others has a 1.0
value for the Max, this parameter is not working at all.
An example of the output follows:
Statistic Value
-------------------------------- ------------------------
Cache Hit Ratio 98.8573
Cache Flushes 4588.0
Free Page Scan (Avg) 184.768
Free Page Scan (Max) 1.0
Min Free Buffers 2048.0
Cache Size 24883.0
Free Buffers 2174.0
If anyone has information on this, or knows where I
can go to get more information, it would be appreciated.
Thanks,
- Craig
View 1 Replies
View Related
Jul 8, 2015
I would like to know if it is possible to date stamp the output file for the DBCC integrity check?
The following cmd works fine however I tried different ways to date stamp the output file with no luck.
sqlcmd -U backup -P Password -S Server -Q"DBCC CHECKDB('DatabaseName') WITH ALL_ERRORMSGS" -o"G:LOGSDBCCResults.txt"
View 5 Replies
View Related
Jun 28, 2001
I have a database with a corrupt table and no matter what I do (dbcc's and rebuilding indexes), there are row fetch errors still occurring daily. My solution now is just to drop the table and recreate it.
Is it as simple as copying the data out of the original table, dropping the original table, and recreating the original table? What about the pointers to other pages? Referential integrety? Please give me a good reference for this subject or let me know. Thank you?
View 1 Replies
View Related
Oct 3, 2005
I get the following errors when I ran dbcc checkdb..
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13015). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:13039). The PageId in the page header = (0:0).
[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 18099105, index ID 0: Page (1:13015) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 18099105, index ID 1. Page (1:12777) is missing a reference from previous page (1:12567). Possible chain linkage problem.
and
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 562101043, index ID 2. The high key value on page (1:1779) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:13072).
What does it mean and how can i resolve them....
Database went into suspect mode , is this the likely cause..
View 20 Replies
View Related
Jul 23, 2005
I have a table in my database called Users:CREATE TABLE [Users] ([UserID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Users_UserID]DEFAULT (newid()),[UserName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[password] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[EmailAddress] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_ASNOT NULL ,[ValidFrom] [datetime] NOT NULL ,[ValidTo] [datetime] NULL ,[passwordSalt] [bigint] NOT NULL ,[FullName] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL ,[CreatorUserID] [uniqueidentifier] NOT NULL ,[DeletorUserID] [uniqueidentifier] NULL ,CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED([UserID],[]) ON [PRIMARY] ,CONSTRAINT [UX_Users_UserName] UNIQUE NONCLUSTERED([UserName]) ON [PRIMARY] ,CONSTRAINT [FK_Users_UsersCreator] FOREIGN KEY([CreatorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [FK_Users_UsersDeletor] FOREIGN KEY([DeletorUserID]) REFERENCES [Users] ([UserID]),CONSTRAINT [CK_Users_Finished] CHECK ([ValidTo] is null and[DeletorUserID] is null or ((not([ValidTo] is null))) and((not([DeletorUserID] is null)))),CONSTRAINT [CK_Users_ValidDates] CHECK ([ValidFrom] <= [ValidTo])) ON [PRIMARY]GOIf you're looking at the Primary Key constraint above, you can probablyalready see the problem (this script was produced by Query Analyzer).If I try to get query analyzer to just script the PK, I get thefollowing error message:[SQL-DMO]The name '' is not a valid object identifier, or is not avalid format for this property or method.I've googled for this phrase, and cannot locate it. If I drop all ofthe constraints in my database, and reapply the constraints to Usersusing the following script:alter table Users add constraintDF_Users_UserID DEFAULT NEWID() FOR UserIDgoalter table Users add constraintPK_Users PRIMARY KEY(UserID) on [PRIMARY]goalter table Users add constraintUX_Users_UserName UNIQUE(UserName)goalter table Users add constraintCK_Users_ValidDates CHECK(ValidFrom <= ValidTo)goalter table Users add constraintCK_Users_Finished CHECK((ValidTo is null andDeletorUserID is null)or(not ValidTo is null andnot DeletorUserID is null))goalter table Users add constraintFK_Users_UsersCreator FOREIGN KEY(CreatorUserID)REFERENCES Users(UserID)goalter table Users add constraintFK_Users_UsersDeletor FOREIGN KEY(DeletorUserID)REFERENCES Users(UserID)goI *still* have this wierd PK. I've checked through both theINFORMATION_SCHEMA views and directly through the system tables, and sofar as they are concerned there is only a single column (UserID) actingas part of the PK.So, any ideas? It appears to be preventing us from setting upreplication. Thankfully, it also occurs in a restored backup of the DB,so I'll be able to reproduce/attempt fixes to my hearts content.Thanks,Damien
View 10 Replies
View Related
Oct 5, 2000
Sql 7. SP 2
After renaming a table Table_tbl to Table_old
and vise-versa.
When selecting from Table_old (for yesterday's data)
I get errors stating that Page belongs to Table_tbl.
Any suggestions on how to successfully rename Old to New, etc.
And not have cross-linked data pages??
View 1 Replies
View Related
Apr 17, 2007
Hi,
I use SQL Server 2000 as a backend database for my Access Front end. It has been working fine for months with no problems.
This morning I arrived in work to find a problem with a table called "TimeSheets". If I try to access the table through Access I get an ODBC timeout error. Likewise, if I open the table in Enterprise manager, it opens fine, but any sorts or if I try to go to the last record, it returns the following error: "[Microsoft][ODBC SQL Server Driver] Timout expired".
So I tried to query the table in SQL Query Analyzer. Everytime it freezes on record 15,936. The table holds 17,643 records.
I tried running DBCC CHECKTABLE ('Timesheets'), and get the following message:
DBCC results for 'Timesheet - Item'.
There are 17643 rows in 401 pages for object 'Timesheet - Item'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I can't see any error messages, but by now I'm reaching the limit of my knowledge of SQL Server.
So, can anybody please help me with this? Any suggestions why my table has apparently become corrupted? Any suggestions how I might fix it?
Thanks a lot for any help
Colin
View 4 Replies
View Related
Sep 14, 2005
Dear group,we are running a SQL-Server Database which is about 30 GB large. Thepurpose of this database is to contain periodic data from automaticdevices which insert values into some tables.Unfortunately most of these tables don't have a key (and a key can onlybe introduced when the application programmers have changed theirsoftware). Tables have this structuredeviceno timestamp datawhere we expect for every device and timestamp one row of data.In the ongoing operation it happens that the index of this large tablegets corrupted and a select from this table yields 2 rows for somedevices.In fact a select "SELECT DEVICENO, TIMESTAMP, COUNT(*) FROM TABLE GROUPBY DEVICENO, TIMESTAMP HAVING COUNT(*) > 1" returns lots of data.After rebuild of the indexes the table is "clean" again.What could cause the index corruption ?Missing key?Faulty application program ?a combination of both ?How can i prevent this from happening again, as long as there is noupdated database / application ?I'd be grateful for any useful commentRegardsUli
View 14 Replies
View Related
Mar 15, 2006
I have an old application running on SQL Server 6.5 (6.50.416) that has a number of internal issues - inability to dump the transaction logs (would dump 9gb out of a 10gb datbase everytime regardless of truncating the logs), transaction log size of 0 even though 700mb allocated, very long DBCC's (though they complete properly).
I am trying to salvage the database by using DTS to copy out the schema, data, sp's, etc. into a new database.
I have the conversion running without error. Data usage goes from almost 10gb down to under 3gb and the transaction logs are now working.
However, when I use DBCC checkdb on the new database, I get the following (just a small sample):
Checking 524528902
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25930 row#=10); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25930 row#=10 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25941 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25941 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x1b20a800, pageno = 25941, status = 0xD, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1794. The offset should be 1384.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=25967 row#=2); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=25967 row#=2 computed row length=527 row length on page=526
Msg 2596, Level 16, State 1
Page pointer = 0x22ab9000, pageno = 25967, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1667. The offset should be 1345.
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26146 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26146 row#=0 computed row length=551 row length on page=550
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26151 row#=5); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26151 row#=5 computed row length=521 row length on page=520
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=26163 row#=0); check adjust table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=26163 row#=0 computed row length=546 row length on page=545
Msg 2596, Level 16, State 1
Page pointer = 0x218ba800, pageno = 26163, status = 0x5, objectid = 524528902, indexid = 0 has an incorrect pgfreeoff value of 1387. The offset should be 577.
etc...
The errors occur only on 3 specific user tables, and are consistent each time I try the conversion. Same exact page numbers and offsets (page pointers are of course different). I do not get any DBCC errors on the original DB at all. I can do select's on the tables without issue, and they seem to have the correct amount of data (did row counts and sums of various columns)
Any insight into what might be causing this or what the actual error is would be welcome.
Thanks,
Brett
View 7 Replies
View Related
Aug 30, 2006
Hi
I have Lookup task to determine if source data should be updated to or insert to the customer table. After Lookup task, the Error Output pipeline will redirect to insert new data to the table and the Output pipeline will update customer table. But these two tasks will be processing at the same time which causes stall on the process. Never end.....
The job is similiart to what Slow Changing Dimention does but it won't update the table at the same time.
What can I do to avoid such situation?
Thanks in advance,
JD
View 4 Replies
View Related
Mar 26, 2007
Hi All,
I am playing with DBCC command to check the contsrainst on a perticular table (DBCC CHECKCONSTRAINTS ('myTable') WITH ALL_CONSTRAINTS), it always gives the following result:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
nothing more than that, anyone can help please?
Cheers,
Riaz
View 3 Replies
View Related
Mar 5, 2005
For Backup Database i used script
BACKUP DATABSE.
Then after that, i need to check Database inigrity, for that
i used DBCC CHECKDB and DBCC CHECKCATALOG
but, i want to store the result in a text file, after executing these two commends, how to write commend line please help me.
View 1 Replies
View Related
Aug 7, 2006
Hi,
I am facing a rather peculiar issue where I am getting a floating point exception error while rebuilding index for a particular table.
--------
Error Number : 3628
Message :
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628: [Microsoft][ODBC SQL Server Driver][SQL Server]A floating point exception occurred in the user process. Current transaction is canceled.
[Microsoft][ODBC SQL Server
------------
This seems to be a rare issue ( as acknowledged by microsoft ) and they seem to suggest that it happens with SQL Server 2000 SP3 . I migrated my database into an SQL Server 2000 SP4 and started the rebuild again .. .. But it still failed with the same error ..
Am just hoping the microsoft guys are wrong and many of you have actually faced this stuff before.. Please let me know.
Thanks in advance,
Ranjit.
View 6 Replies
View Related
May 10, 2007
Does anyone know if there is a simple way to get the results of a DBCCINPUTBUFFER() request into a table? I have a process for monitoringactivity that will give me the results of sp_who2 into a temp table,and want to scroll through the active connections and get the inputbuffers into another table for review:Insert into #TmpWhoexec sp_who2 'active'Something like that with the dbcc command.I am using SQL 2000 SP4.Thanks,Tom
View 3 Replies
View Related
Jan 3, 2001
Hi all,
I want to save DBCC's result into a table to execute my statement but I don't know how to, exmple for DBCC OPENTRAN (my database) - how can I put SPID & UID to my variable from this statement?
Thanks in advance
Happy New Year
PTH
View 1 Replies
View Related
Jan 9, 2007
Following the below topic:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271
I followed the advice of Paul Randal, but Im stumped as I am not able to determin what the corruption issues are. This is SQL 2000 and the database is a Solomon database that was recently upgraded to 6.5. the error I get when running the DBCC checkdb is as follows:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:18645) with latch type SH. sysindexes failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
When I run select * from sysindexes, I get:
Server: Msg 3624, Level 20, State 1, Line 1
Location: blobman.cpp:1780
Expression: sourceLength == sizeof (TextPointer)
SPID: 53
Process ID: 256
Connection Broken
When I run dbcc page (dbname, 1, 18645, 3)
dbcc traceon(3604), It finishes with what appears to be no errors log is as follows:
PAGE: (1:18645)
---------------
BUFFER:
-------
BUF @0x0144C880
---------------
bpage = 0x681B4000 bhash = 0x00000000 bpageno = (1:18645)
bdbid = 12 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x681B4000
----------------
m_pageId = (1:18645) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x2
m_objId = 2 m_indexId = 0 m_prevPage = (1:505)
m_nextPage = (1:213) pminlen = 82 m_slotCnt = 16
m_freeCnt = 3988 m_freeData = 5796 m_reservedCnt = 0
m_lsn = (42700:4549:10) m_xactReserved = 0 m_xdesId = (0:2539719)
m_ghostRecCnt = 0 m_tornBits = 0
Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:16176) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED
Slot 0 Offset 0xf8c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4F8C: 00520030 013f142a 00004012 00000000 0.R.*.?..@......
681B4F9C: 00010000 00000000 02600000 00010001 ..........`.....
681B4FAC: 00000000 00000000 00000000 00000000 ................
681B4FBC: 00000000 00000000 027a0000 00000022 ..........z."...
681B4FCC: 00000000 00000000 00000000 00000000 ................
681B4FDC: 001b0000 00000000 00800003 80a60096 ................
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
681B500C: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B501C: 00680063 00000030 002a869d 00570000 c.h.0.....*...W.
681B502C: 00010000 0007 ......
id = 20911146
status = 16402
first = 0
indid = 1
root = 0
minlen = 608
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 634
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4FEC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4FFC: 0001000a 00000000 00010016 00000000 ................
name = smInvBatch0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647062528 RowId = (1:87:7)
Slot 1 Offset 0x12c4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B52C4: 00520030 013f142a 00000000 00000000 0.R.*.?.........
681B52D4: 00020000 00000000 00150000 00010003 ................
681B52E4: 00000000 00000000 00000000 00000000 ................
681B52F4: 00000000 00000000 00260000 0000002c ..........&.,...
681B5304: 00000000 00000000 00000000 00000000 ................
681B5314: 001b0000 00000000 00c00003 80e600d6 ................
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
681B5384: 006d0073 006e0049 00420076 00740061 s.m.I.n.v.B.a.t.
681B5394: 00680063 00000031 002a869f 00570000 c.h.1.....*...W.
681B53A4: 00010000 0008 ......
id = 20911146
status = 0
first = 0
indid = 2
root = 0
minlen = 21
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 38
maxirow = 44
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B5324: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5334: 00010016 00000000 00010072 00000000 ........r.......
681B5344: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5354: 000b000a 00000000 000b0016 00000000 ................
681B5364: 00af03af 0000000a 3400d008 00000000 ...........4....
681B5374: 000b000a 00000000 00010016 00030000 ................
name = smInvBatch1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182647193600 RowId = (1:87:8)
Slot 2 Offset 0x1440
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B5440: 00520030 01584911 00004012 000000c6 0.R..IX..@......
681B5450: 00010001 00000095 09a20001 00010001 ................
681B5460: 00000001 00000005 00000005 00000000 ................
681B5470: 00000000 00000003 09ba0000 0000001a ................
681B5480: 00000000 00000096 00000001 00000000 ................
681B5490: 001b0000 00000000 00800003 80a60096 ................
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
681B54C0: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B54D0: 0065006d 00000030 002a87a9 03a00000 m.e.0.....*.....
681B54E0: 00010000 0019 ......
id = 22563089
status = 16402
first = 0
indid = 1
root = 0
minlen = 2466
keycnt = 1
groupid = 1
dpages = 1
reserved = 5
used = 5
rowcnt = 0
rowmodctr = 3
reserved3 = 0
reserved4 = 0
xmaxlen = 2490
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B54A0: 00340134 00050002 00000000 00000000 4.4.............
681B54B0: 00010020 00000000 000102c1 00000000 ...............
name = RptRuntime0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664626176 RowId = (1:928:25)
Slot 3 Offset 0x15bc
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B55BC: 00520030 01584911 00000000 000000e6 0.R..IX.........
681B55CC: 00020001 000000e6 00470001 00010003 ..........G.....
681B55DC: 00000001 00000002 00000002 00000000 ................
681B55EC: 00000000 00000000 00580000 0000005e ..........X.^...
681B55FC: 00000000 00000161 00000001 00000000 ....a...........
681B560C: 001b0000 00000000 00c00003 80e600d6 ................
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
681B567C: 00700052 00520074 006e0075 00690074 R.p.t.R.u.n.t.i.
681B568C: 0065006d 00000031 002a87ab 3eb70000 m.e.1.....*....>
681B569C: 00010000 0004 ......
id = 22563089
status = 0
first = 0
indid = 2
root = 0
minlen = 71
keycnt = 3
groupid = 1
dpages = 1
reserved = 2
used = 2
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 88
maxirow = 94
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B561C: 00af03af 00000015 3400d008 00000000 ...........4....
681B562C: 00010008 00000000 0001004b 00000000 ........K.......
681B563C: 00af03af 0000002f 3400d008 00000000 ..../......4....
681B564C: 0016003f 00000000 0016096b 00000000 ?.......k.......
681B565C: 00340134 00050002 00000000 00000000 4.4.............
681B566C: 00450020 00000000 000102c1 00010000 .E.............
name = RptRuntime1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182664757248 RowId = (1:16055:4)
Slot 4 Offset 0xc04
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4C04: 00520030 0175b502 00004012 00000000 0.R...u..@......
681B4C14: 00010000 00000000 040c0000 00010001 ................
681B4C24: 00000000 00000000 00000000 00000000 ................
681B4C34: 00000000 00000000 04270000 00000022 ..........'."...
681B4C44: 00000000 00000000 00000000 00000000 ................
681B4C54: 001b0000 00000000 00800003 80a60096 ................
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
681B4C84: 006f0057 006b0072 00650043 0074006e W.o.r.k.C.e.n.t.
681B4C94: 00720065 00000030 002a84b7 55880000 e.r.0.....*....U
681B4CA4: 00010000 0007 ......
id = 24491266
status = 16402
first = 0
indid = 1
root = 0
minlen = 1036
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1063
maxirow = 34
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4C64: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4C74: 0001004e 00000000 000103e6 00000000 N...............
name = WorkCenter0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182615212032 RowId = (1:21896:7)
Slot 5 Offset 0xb64
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4B64: 00520030 01ab548a 00004012 00000000 0.R..T...@......
681B4B74: 00010000 00000000 038e0000 00010001 ................
681B4B84: 00000000 00000000 00000000 00000000 ................
681B4B94: 00000000 00000000 03b00000 0000001a ................
681B4BA4: 00000000 00000000 00000000 00000000 ................
681B4BB4: 001b0000 00000000 00800003 80a00090 ................
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
681B4BE4: 004f0053 00650053 00750074 00300070 S.O.S.e.t.u.p.0.
681B4BF4: 84010000 0000002a 00000f23 00070001 ....*...#.......
id = 28005514
status = 16402
first = 0
indid = 1
root = 0
minlen = 910
keycnt = 1
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 944
maxirow = 26
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4BC4: 00af03af 00000002 3400d008 00000000 ...........4....
681B4BD4: 0001007b 00000000 000102bb 00000000 {...............
name = SOSetup0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182603284480 RowId = (1:3875:7)
Slot 6 Offset 0x58c
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B458C: 00520030 01c4f563 00004012 00000000 0.R.c....@......
681B459C: 00010000 00000000 04c70000 00010002 ................
681B45AC: 00000000 00000000 00000000 00000000 ................
681B45BC: 00000000 00000000 04e80000 00000027 ............'...
681B45CC: 00000000 00000000 00000000 00000000 ................
681B45DC: 001b0000 00000000 00a00003 80c400b4 ................
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
681B462C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B463C: 00300074 82fd0000 0000002a 0000068a t.0.....*.......
681B464C: 00490001 ..I.
id = 29685091
status = 16402
first = 0
indid = 1
root = 0
minlen = 1223
keycnt = 2
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 1256
maxirow = 39
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B45EC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B45FC: 00010034 00000000 0001016e 00000000 4.......n.......
681B460C: 00af03af 00000005 3400d008 00000000 ...........4....
681B461C: 000b002a 00000000 000b0135 00000000 *.......5.......
name = PurOrdDet0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586245120 RowId = (1:1674:73)
Slot 7 Offset 0x650
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4650: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4660: 00020000 00000000 002e0000 00010003 ................
681B4670: 00000000 00000000 00000000 00000000 ................
681B4680: 00000000 00000000 003f0000 00000045 ..........?.E...
681B4690: 00000000 00000000 00000000 00000000 ................
681B46A0: 001b0000 00000000 00c00003 80e400d4 ................
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
681B4710: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4720: 00310074 83040000 0000002a 0000068a t.1.....*.......
681B4730: 004a0001 ..J.
id = 29685091
status = 0
first = 0
indid = 2
root = 0
minlen = 46
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 63
maxirow = 69
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B46B0: 00af03af 0000001e 3400d008 00000000 ...........4....
681B46C0: 00010024 00000000 00010109 00000000 $...............
681B46D0: 00af03af 0000000a 3400d008 00000000 ...........4....
681B46E0: 001f0034 00000000 0001016e 00010000 4.......n.......
681B46F0: 00af03af 00000005 3400d008 00000000 ...........4....
681B4700: 0029002a 00000000 000b0135 00010000 *.).....5.......
name = PurOrdDet1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586703872 RowId = (1:1674:74)
Slot 8 Offset 0x734
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4734: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4744: 00030000 00000000 00340000 00010004 ..........4.....
681B4754: 00000000 00000000 00000000 00000000 ................
681B4764: 00000000 00000000 00450000 0000004b ..........E.K...
681B4774: 00000000 00000000 00000000 00000000 ................
681B4784: 001b0000 00000000 00e00003 810400f4 ................
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
681B4814: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4824: 00320074 83050000 0000002a 0000068a t.2.....*.......
681B4834: 004b0001 ..K.
id = 29685091
status = 0
first = 0
indid = 3
root = 0
minlen = 52
keycnt = 4
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 69
maxirow = 75
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4794: 00af03af 00000006 3400d008 00000000 ...........4....
681B47A4: 00010044 00000000 000101ea 00000000 D...............
681B47B4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B47C4: 00070024 00000000 00070109 00000000 $...............
681B47D4: 00af03af 0000000a 3400d008 00000000 ...........4....
681B47E4: 00250034 00000000 0001016e 00010000 4.%.....n.......
681B47F4: 00af03af 00000005 3400d008 00000000 ...........4....
681B4804: 002f002a 00000000 000b0135 00010000 *./.....5.......
name = PurOrdDet2
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586769408 RowId = (1:1674:75)
Slot 9 Offset 0x838
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4838: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4848: 00040000 00000000 00120000 00010005 ................
681B4858: 00000000 00000000 00000000 00000000 ................
681B4868: 00000000 00000000 00230000 00000029 ..........#.)...
681B4878: 00000000 00000000 00000000 00000000 ................
681B4888: 001b0000 00000000 01000003 81240114 ..............$.
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
681B4938: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4948: 00330074 83060000 0000002a 0000068a t.3.....*.......
681B4958: 004c0001 ..L.
id = 29685091
status = 0
first = 0
indid = 4
root = 0
minlen = 18
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 35
maxirow = 41
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4898: 00af03af 0000000a 3400d008 00000000 ...........4....
681B48A8: 00010034 00000000 0001016e 00000000 4.......n.......
681B48B8: 00af03af 00000005 3400d008 00000000 ...........4....
681B48C8: 000b002a 00000000 000b0135 00000000 *.......5.......
681B48D8: 00340134 00050002 00000000 00000000 4.4.............
681B48E8: 00100029 00000000 00100133 00000000 ).......3.......
681B48F8: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4908: 00010034 00000000 0001016e 00030000 4.......n.......
681B4918: 00af03af 00000005 3400d008 00000000 ...........4....
681B4928: 000b002a 00000000 000b0135 00030000 *.......5.......
name = PurOrdDet3
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586834944 RowId = (1:1674:76)
Slot 10 Offset 0x95c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B495C: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B496C: 00050000 00000000 003a0000 00010005 ..........:.....
681B497C: 00000000 00000000 00000000 00000000 ................
681B498C: 00000000 00000000 004b0000 00000051 ..........K.Q...
681B499C: 00000000 00000000 00000000 00000000 ................
681B49AC: 001b0000 00000000 01000003 81240114 ..............$.
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
681B4A5C: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4A6C: 00340074 83070000 0000002a 0000068a t.4.....*.......
681B4A7C: 004d0001 ..M.
id = 29685091
status = 0
first = 0
indid = 5
root = 0
minlen = 58
keycnt = 5
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 75
maxirow = 81
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B49BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B49CC: 00010024 00000000 00010109 00000000 $...............
681B49DC: 00af03af 0000000a 3400d008 00000000 ...........4....
681B49EC: 001f005e 00000000 001f032b 00000000 ^.......+.......
681B49FC: 00340134 00050002 00000000 00000000 4.4.............
681B4A0C: 0029002f 00000000 00290154 00000000 /.).....T.).....
681B4A1C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4A2C: 002b0034 00000000 0001016e 00010000 4.+.....n.......
681B4A3C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4A4C: 0035002a 00000000 000b0135 00010000 *.5.....5.......
name = PurOrdDet4
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586900480 RowId = (1:1674:77)
Slot 11 Offset 0xa80
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4A80: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4A90: 00060000 00000000 00200000 00010003 .......... .....
681B4AA0: 00000000 00000000 00000000 00000000 ................
681B4AB0: 00000000 00000000 00310000 00000037 ..........1.7...
681B4AC0: 00000000 00000000 00000000 00000000 ................
681B4AD0: 001b0000 00000000 00c00003 80e400d4 ................
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
681B4B40: 00750050 004f0072 00640072 00650044 P.u.r.O.r.d.D.e.
681B4B50: 00350074 83080000 0000002a 0000068a t.5.....*.......
681B4B60: 004e0001 ..N.
id = 29685091
status = 0
first = 0
indid = 6
root = 0
minlen = 32
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 49
maxirow = 55
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4AE0: 00af03af 00000010 3400d008 00000000 ...........4....
681B4AF0: 00010036 00000000 0001017a 00000000 6.......z.......
681B4B00: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4B10: 00110034 00000000 0001016e 00010000 4.......n.......
681B4B20: 00af03af 00000005 3400d008 00000000 ...........4....
681B4B30: 001b002a 00000000 000b0135 00010000 *.......5.......
name = PurOrdDet5
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182586966016 RowId = (1:1674:78)
Slot 12 Offset 0xcac
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B4CAC: 00520030 01c4f563 00000000 00000000 0.R.c...........
681B4CBC: 00070000 00000000 00110000 00010003 ................
681B4CCC: 00000000 00000000 00000000 00000000 ................
681B4CDC: 00000000 00000000 00220000 00000028 ..........".(...
681B4CEC: 00000000 00000000 00000000 00000000 ................
681B4CFC: 001b0000 00000000 00c00003 80ee00de ................
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
681B4D6C: 00750070 006f0072 00640072 00650064 p.u.r.o.r.d.d.e.
681B4D7C: 005f0074 00740073 00610072 0000006e t._.s.t.r.a.n...
681B4D8C: 002a84c7 78450000 00010000 001d ..*...Ex......
id = 29685091
status = 0
first = 0
indid = 7
root = 0
minlen = 17
keycnt = 3
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 34
maxirow = 40
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4D0C: 00af03af 00000001 3400d008 00000000 ...........4....
681B4D1C: 00010033 00000000 0001016d 00000000 3.......m.......
681B4D2C: 00af03af 0000000a 3400d008 00000000 ...........4....
681B4D3C: 00020034 00000000 0001016e 00010000 4.......n.......
681B4D4C: 00af03af 00000005 3400d008 00000000 ...........4....
681B4D5C: 000c002a 00000000 000b0135 00010000 *.......5.......
name = purorddet_stran
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182616260608 RowId = (1:30789:29)
Slot 13 Offset 0xd4
-------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B40D4: 00520030 01d345b0 00004012 00000000 0.R..E...@......
681B40E4: 00010000 00000000 019b0000 00010006 ................
681B40F4: 00000000 00000000 00000000 00000000 ................
681B4104: 00000000 00000000 01b00000 0000007b ............{...
681B4114: 00000000 00000000 00000000 00000000 ................
681B4124: 001b0000 00000000 01200003 81460136 .......... .6.F.
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
681B41F4: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4204: 006c0063 00000030 002a8221 4d150000 c.l.0...!.*....M
681B4214: 00010000 003f ....?.
id = 30623152
status = 16402
first = 0
indid = 1
root = 0
minlen = 411
keycnt = 6
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 432
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4134: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4144: 00010008 00000000 00010041 00000000 ........A.......
681B4154: 00af03af 00000004 3400d008 00000000 ...........4....
681B4164: 001f0007 00000000 001f003d 00000000 ........=.......
681B4174: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4184: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4194: 00af03af 00000001 3400d008 00000000 ...........4....
681B41A4: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B41B4: 00af03af 00000004 3400d008 00000000 ...........4....
681B41C4: 00420004 00000000 0042001a 00000000 ..B.......B.....
681B41D4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B41E4: 00460005 00000000 0046001e 00000000 ..F.......F.....
name = OptDepExcl0
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182571827200 RowId = (1:19733:63)
Slot 14 Offset 0x21c
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B421C: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B422C: 00020000 00000000 00640000 00010008 ..........d.....
681B423C: 00000000 00000000 00000000 00000000 ................
681B424C: 00000000 00000000 00750000 0000007b ..........u.{...
681B425C: 00000000 00000000 00000000 00000000 ................
681B426C: 001b0000 00000000 01600003 81860176 ..........`.v...
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
681B437C: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B438C: 006c0063 00000031 002a8224 4d150000 c.l.1...$.*....M
681B439C: 00010000 0040 ....@.
id = 30623152
status = 0
first = 0
indid = 2
root = 0
minlen = 100
keycnt = 8
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 117
maxirow = 123
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B427C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B428C: 00010005 00000000 0001001e 00000000 ................
681B429C: 00af03af 00000004 3400d008 00000000 ...........4....
681B42AC: 001f0004 00000000 001f001a 00000000 ................
681B42BC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B42CC: 00230008 00000000 00010041 00010000 ..#.....A.......
681B42DC: 00af03af 00000004 3400d008 00000000 ...........4....
681B42EC: 00410007 00000000 001f003d 00010000 ..A.....=.......
681B42FC: 00af03af 0000001e 3400d008 00000000 ...........4....
681B430C: 00450010 00000000 00230084 00010000 ..E.......#.....
681B431C: 00af03af 00000001 3400d008 00000000 ...........4....
681B432C: 00630006 00000000 0041003c 00010000 ..c.....<.A.....
681B433C: 00af03af 00000004 3400d008 00000000 ...........4....
681B434C: 001f0004 00000000 0042001a 00030000 ..........B.....
681B435C: 00af03af 0000001e 3400d008 00000000 ...........4....
681B436C: 00010005 00000000 0046001e 00030000 ..........F.....
name = OptDepExcl1
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572023808 RowId = (1:19733:64)
Slot 15 Offset 0x3a4
--------------------
Record Type = PRIMARY_RECORD
Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
681B43A4: 00520030 01d345b0 00000000 00000000 0.R..E..........
681B43B4: 00030000 00000000 00660000 0001000b ..........f.....
681B43C4: 00000000 00000000 00000000 00000000 ................
681B43D4: 00000000 00000000 00770000 0000007d ..........w.}...
681B43E4: 00000000 00000000 00000000 00000000 ................
681B43F4: 001b0000 00000000 01c00003 81e601d6 ................
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
681B4564: 0070004f 00440074 00700065 00780045 O.p.t.D.e.p.E.x.
681B4574: 006c0063 00000032 002a8225 4d150000 c.l.2...%.*....M
681B4584: 00010000 0041 ....A.
id = 30623152
status = 0
first = 0
indid = 3
root = 0
minlen = 102
keycnt = 11
groupid = 1
dpages = 0
reserved = 0
used = 0
rowcnt = 0
rowmodctr = 0
reserved3 = 0
reserved4 = 0
xmaxlen = 119
maxirow = 125
OrigFillFactor = 0
StatVersion = 0
reserved2 = 0
FirstIAM = 0
impid = 0
lockflags = 0
pgmodctr = 0
keys
--------------------------------
681B4404: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4414: 00010008 00000000 00010041 00000000 ........A.......
681B4424: 00af03af 00000004 3400d008 00000000 ...........4....
681B4434: 001f0007 00000000 001f003d 00000000 ........=.......
681B4444: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4454: 00230010 00000000 00230084 00000000 ..#.......#.....
681B4464: 00af03af 00000001 3400d008 00000000 ...........4....
681B4474: 00410006 00000000 0041003c 00000000 ..A.....<.A.....
681B4484: 00340134 00050002 00000000 00000000 4.4.............
681B4494: 0042000a 00000000 00420063 00000000 ..B.....c.B.....
681B44A4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44B4: 00010008 00000000 00010041 00030000 ........A.......
681B44C4: 00af03af 00000004 3400d008 00000000 ...........4....
681B44D4: 001f0007 00000000 001f003d 00030000 ........=.......
681B44E4: 00af03af 0000001e 3400d008 00000000 ...........4....
681B44F4: 00230010 00000000 00230084 00030000 ..#.......#.....
681B4504: 00af03af 00000001 3400d008 00000000 ...........4....
681B4514: 00410006 00000000 0041003c 00030000 ..A.....<.A.....
681B4524: 00af03af 00000004 3400d008 00000000 ...........4....
681B4534: 00440004 00000000 0042001a 00010000 ..D.......B.....
681B4544: 00af03af 0000001e 3400d008 00000000 ...........4....
681B4554: 00480005 00000000 0046001e 00010000 ..H.......F.....
name = OptDepExcl2
statblob = [TextPointer]
------------------------------------------------
TextTimeStamp = 182572089344 RowId = (1:19733:65)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Now, the bad news. I am a bit of a novice and have picked this up from someone who left my company. It appears the latch error has been around for some time and only reared up when I instituted a new back up system that runs a dbcc check befor backing up. I don't think I have any clean backups.
Any help would be greatly appreciated.
Alex Mauer
View 17 Replies
View Related
Jul 20, 2005
Can someone please help me interpret this result set below and suggeston way I can speed up my table? What changes should I make?DBCC SHOWCONTIG scanning 'tblListing' table...Table: 'tblListing' (1092914965); index ID: 1, database ID: 13TABLE level scan performed.- Pages Scanned................................: 97044- Extents Scanned..............................: 12177- Extent Switches..............................: 13452- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 90.17% [12131:13453]- Logical Scan Fragmentation ..................: 0.86%- Extent Scan Fragmentation ...................: 2.68%- Avg. Bytes Free per Page.....................: 1415.8- Avg. Page Density (full).....................: 82.51%DBCC execution completed. If DBCC printed error messages, contact yoursystem administrator.Thank you.
View 2 Replies
View Related
Feb 19, 2008
Hi:
how could I load "DBCC showcontig (@TableName) with tableResults" to a table?
I created a table and let insert to it via above "DBCC...."
but problem is the results with "DBCC execution completed. If DBCC printed error messages, contact your system administrator.", or how could I mute this output line for each table ?
thanks
David
--=========================================
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
ObjectName ObjectId IndexName IndexId Level Pages Rows MinimumRecordSize MaximumRecordSize AverageRecordSize ForwardedRecords Extents ExtentSwitches AverageFreeBytes AveragePageDensity ScanDensity BestCount ActualCount LogicalFragmentation ExtentFragmentation
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- -------------------- -------------------- ----------------- ----------------- ---------------------- -------------------- -------------------- -------------------- ---------------------- ---------------------- ---------------------- -------------------- -------------------- ---------------------- ----------------------
sysproxylogin 37575172 clust 1 0 0 0 0 0 0 0 0 0 0 0 100 0 0 0 0
View 1 Replies
View Related
Jul 23, 2015
I have a database that has had a full text index at some point in it's history - but no longer does. The database is currently at SQL 2012 compatibility, but it was created on SQL2000. It still appears to have a row in the internal table sys.sysftinds - but some of the column values are NULL, and NULLs are not allowed. The database fails DBCC checks because of this.
Msg 8970, Level 16, State 1, Line 2
Row error: Object ID 25, index ID 1, partition ID xxxx,
alloc unit ID xxxx (type In-row data),
page ID (1:xxxx), row ID 0. Column 'sensitivity' was created NOT NULL, but is NULL in the row.
DBCC results for 'sys.sysftinds'.
There are 1 rows in 1 pages for object "sys.sysftinds".
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sys.sysftinds' (object ID 25).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (xxxx.sys.sysftinds).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Running DBCC with repair_allow_data_loss has not worked.
View 6 Replies
View Related
Jan 21, 2008
Hello,
I am facing an issue with a table in my database.
1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad
2) No queries, even queries that would return only 1 record complete execution against that table
3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.
4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.
5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.
6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table
7) I am unable to Drop the Table
8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.
9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.
Can one of the SQL Gurus on this forum please recommend a course of action.
Thanks in advance.
View 1 Replies
View Related
May 11, 2006
What factors would make you decide to use DBCC DBREINDES instead of DBCC DEFRAG when you notice index defragmantation?
Thanks.
ekareem
View 1 Replies
View Related
Jul 4, 2006
Hi everyone,
While creating a stored prodecure, I now that it is possible to use an output parameter which is a table. However, I do not know how to do it ??
In other words, I would like to return a table but as an output parameter, so how can this happen ?
View 5 Replies
View Related
Aug 20, 2007
Hi gurus
Please help me to get out the problem ... i wanna store the output of SP_MONITOR into a table. Please let me know how can i do this
Thanks & Regards
Chander
View 7 Replies
View Related
Sep 7, 2006
First some background info.
SQL Express
Visual Studio 2005
VB.Net
Data.SQLClient Namespace
Well I was using the OUTPUT option in my program and it was great, i was returning my PrimaryKey from the newly inserted row. (I am using paramaters in my program and running a sqlCommand.ExecuteScalar)
--Example Insert
"Insert into tblInfo (fldInfo,fldDate) OUTPUT inserted.fldInfoID values (@fldInfo, @fldDate)"
Then I found a problem...:(
I added trigger to the tblInfo, that after a Insert,Update, Delete it would perform a audit on the table saving the old info that was overritten, type of action taken (insert, update or delete), and who did it.
Well my OUTPUT didn't like that says, it can't do a OUTPUT on a table with a trigger.
--Error msg
Msg 334, Level 16, State 1, Line 1
The target table 'tblInfo' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.
So what am i supose to do? I want the audit to occur, but I walso want the primarykey without doing a select (maxID) which could potentially get the wrong id (multiuser).
Any suggestions?
Thanks,
Jordon
View 3 Replies
View Related
Apr 11, 2007
I used the oTable.Script method to output the DDL for a Sql Server 2000 user defined table. The result is DDL with an error. I don't think the problem is with DMO itself so I posted this here. Note the 'TEXTIMAGE_ON ' clause. The table does not have a text column, and the DDL will not execute.
CREATE TABLE [MyTable] (
[FilterID] [int] IDENTITY (1, 1) NOT NULL ,
[LoanAgentID] [int] NOT NULL ,
[Key] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[IsActive] [int] NOT NULL ,
[tStamp] [timestamp] NOT NULL ,
[Formula] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[_AuditAddDt] [datetime] NOT NULL ,
[_AuditUpdateDt] [datetime] NOT NULL ,
CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED
(
[FilterID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Server: Msg 1709, Level 16, State 1, Line 1
Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns.
Any ideas?
Thanks!
View 3 Replies
View Related
Jul 10, 2006
Hi
I run a SQL query to select a few colums of data using a select statement, I want the output to be stored in the new table which can be defined in the SQL statement how can I do it?
Your helpwill bw highly appreciated.
View 5 Replies
View Related
May 14, 2007
Hi,
I've been looking into using the ability to select the table of an OLEDB destination task based on a package variable but would like to know if this could be utilised in the following example.
I have a CSV file (potentially there are many) with a number of rows. The rows do not necessarily contain the same number of elements. Each row has an EventID and this is used to determine the database table that the row is to be inserted in.
Initially i thought about using a conditional split to send each row down the path relating to its event ID. There would be multiple destinations depending on the table. With the possibility of 60 to 70 different event ID's this is very quickly going to get out of hand in the designer. I'd like to know if it would be possible to set up a case statement (or similar) in a script component and specify the table name as a variable depending on the event ID. I'd then use this table variable to set the destination task's table property.
Does this sound like a possibility or do i have to go down the route of multiple paths?
Many thanks in advance,
Grant
View 3 Replies
View Related
Mar 26, 1999
The MS SQL Server SQLMaint Utility returned this error:
[4] Check System Data...
The following errors were found:
Database Corrupt: The last checkpoint in Sysdatabases is incorrect.
Syslogs recorded a different checkpoint
** Execution Time: 0 hrs, 0 mins, 1 secs **
I've read that this is no big deal, that a row in the sysdatabases table
hasn't been updated to reflect the latest checkpoint, and that rebooting
the server would clear this. However, rebooting did not clear it.
Any ideas?
W.
View 1 Replies
View Related
