SQLTeam.com | Weblogs | Forums

SQL Indexing all wrong

I will try to explain this as easily as I can.

My one table has Indexing messed up, or so it seems.

I have ran into this issue within the last few weeks and not sure what is causing this.

I currently have 815 INDEXED lines within one SQL database. There are "holes" if you will where some index numbers were assigned but the record deleted for various reasons. I know those index numbers are never used again and will show as a gap, if you will, in the numerical listing. This is not my concern.

FURTHER detail to clarify....

My concern is within the last week when I want to add a new row (index) I initially receive an error that there is no row at position 815 (currently the last record is at index 815). If I exit out of that message box and create the record anyways and save it the record saves fine and takes the next available index number.

I then import expenses, via a second form within the program, that looks at a primary key field and writes to the record as required... this has ceased recently. When I try to import expenses and save the data to the proper record I now receive the error "An item with the same key has already been added."

Using VB debug it shows it is trying to create a record at index 812 when that index is already used. The record at Index 812 is the last record that actually "works." 3 records have been added since, thus why currently there is now Index 815 in the database.

Is there a proper repair for the SQL indexing that I can use? I tried a few items but it does not seem to resolve the issue. I used the MSSMS Reorganize as well as Rebuild tools but that did not resolve the issue.

Is it possible something is amiss in the program? Nothing has been changed in this program for sometime (6 months maybe) and worked fine up to a couple of weeks ago. The ONLY change was upgrading from VS 2015 to VS 2017 and recompiled using the 2017 compiler. Could that potentially cause something to go awry?

I did run "DBCC checkdb" and the following returned (not including everything just the last few lines:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'PETS_Database'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  1. The terminology you are using seems off. I think you mean primary key and not index.
  2. When importing, does the file you are importing from have "Index" numbers?
    Why is that the case? Where are these expense files coming from?

I dont think the issues you mentioned are the cause, I think it is a programmatic and architecture issue more than anything imo

This doesn't sound like a problem with the database but with the application.
Did you write that yourself if so you need to look at why it isn't getting the correct info from the database - if not go back to the developers. Check whether the app works for the new version - the database layer will have changed and maybe that's causing the issue.

It sounds like it is correctly detecting the maximum index value (I'm guessing an not an identity but something maintained by the app) but has a problem when trying to retrieve the row - but the write is ok (that imples that if it's an identity then it has the correct seed).
For the import it seems that it isn't getting the correct last value. Maybe it maintains something separate from the table to hold the last value and that has got lost - maybe something local to the app or something that the app isn't setting correctly now - I assume you have restarted that so it should synchronise.

Could also be that the app isn't actually using the value but expects the data to be in order and is using a position pointer - if so then it's just lucky that it's worked in the past. Are there 812 rows in the table or are the other 3 rows the data that has been written since the upgrade?

The terminology you are using - new row (index), position, index 815 makes me think something odd is going on.
Do you mean there is an integer column with a consecutive value set on write and that column is indexed?

There are roughly 776 total rows in the DB. Last INDEX is on 815 in the database. There were some records that have been deleted for any various reasons. This explains why INDEX is 815 when only 776 actual rows are in the db.

The program is trying to write INDEX 812, which already exists... and has not been deleted.

If I go past the incorrect index message, it correctly writes to the next INDEX value, in which case the next record to be written would be index 816.

Record INDEX 813-815 were written after this problem first presented itself. Yet the program is stuck and is insistent it needs to write to index 812. The index is NOT the ID field as that is a separate field.

The program was authored primarily by me and has worked fine up to a week ago. Very few changes to the forms were made and nothing related to "updates" or writes have been made to the program. Cosmetic and spelling corrections to the form were the only things changed other than compiling under VS 2017 from VS 2015.

The expense information is written to a separate database. Once that data is saved to the EXPENSE_TABLE an import is done to the LOAD_INFO_TABLE from the EXPENSE TABLE where applicable. Some expenses are not imported as they are not relevant to the LOAD_INFO_TABLE.

Again this entire system worked fine up to about a week ago.

As a test, I did go back to older code (where there is definitely some differences) on both the Load Input form as well as the Expense form (last updated from mid last year) and am experiencing the exact same problem where I guarantee all this worked fine.

Once I load the program I can step forward, backward, 1st, last record and the form fills fine, no issue, no errors no complaints. the only issue is in the write new. Even if I make a change on the form of a loaded record it updates and saves fine.

I apologize for my lack of terminology as I am fairly new to this and not as experienced in these deep issues. Thus why I come to the pros!

Please post vb code that does the write? Are you using stored procedures to write the data?

Not using stored procedure.

The problem happens at the very beginning when a new record is being created... ie when I hit "add new" it immediately gives the error.

I'm not convinced this is a write error as the record writes/updates fine once I generate the record.

Post your table schemas and the part of the code where it does the insert

Hoping this is what you are wanting to see:

    Private Sub BtnStartNew_Click(sender As Object, e As EventArgs) Handles btnStartNew.Click
    If Not LoadForm Then
        Dirty()
        LoadInfoDataSetBindingSource.AddNew()
    End If
End Sub

Private Sub NavSaveBtnLoad_Click(sender As Object, e As EventArgs) Handles btnSaveNav.Click
    Cursor = Cursors.WaitCursor
    'tbCheck()
    Try
        'ImportTotals()
        Validate()
        LoadInfoDataSetBindingSource.EndEdit()
        Load_Info_TableTableAdapter.Update(LoadInfoDataSet.Load_Info_Table)

        'If a save is successful, show Save Successful message box
        MeMsgBoxSave.ShowDialog()

    Catch ex As Exception
        'If a save error occurs, show Error message box
        Call New MeMsgBoxError(ex).ShowDialog()
    End Try
    Cursor = Cursors.Default
End Sub
PETS_Database dbo Load_Info_Table ID 1 NULL NO int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ACT_MILES_DIFF_CALC 2 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ACTUAL_DH_MILES 3 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ACTUAL_LOADED_MILES 4 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ADJUSTED_MILEAGE 5 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table AGENT_FEE 6 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table AGENT_NAME 7 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table AGENT_PHONE 8 NULL YES nvarchar 25 50 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_DATE_01 9 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_DATE_02 10 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_DATE_90 11 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_EARLY 12 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_TIME_01 13 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_TIME_02 14 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table ARRIVE_TIME_90 15 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table BOL 16 NULL YES varchar -1 -1 NULL NULL NULL NULL NULL NULL iso_1 NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table BOL_WEIGHT 17 ((0)) YES numeric NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table BROKER_AGENCY 18 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table CARRIER_DH_MILES 19 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table CARRIER_LOAD_NUMBER 20 ((0)) YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table CARRIER_LOADED_MILES 21 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table CLAIM 22 NULL YES nvarchar 10 20 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table CLAIM_AMOUNT 23 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table CLAIM_NUMBER 24 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table COST_PER_MILE 25 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DATE_PAID 26 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEF_GALS_TOT 27 NULL YES decimal NULL NULL 5 10 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEF_PURCHASED 28 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_DATE_01 29 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_DATE_02 30 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_DATE_90 31 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_TIME_01 32 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_TIME_02 33 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DEPART_TIME_90 34 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DETENTION_OVERRIDE_01 35 NULL YES bit NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DETENTION_OVERRIDE_90 36 NULL YES bit NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DETENTION_OWED 37 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DETENTION_PAID 38 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DH_MILES_DIFF_CALC 39 ((0)) YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DISPATCH_DATE 40 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DISPATCH_TIME 41 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DOCK_TIME_01 42 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DOCK_TIME_02 43 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DOCK_TIME_90 44 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DRIVER_COUNT 45 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table DROP_CONFIRM 46 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table DROP_DATE 47 NULL YES datetime2 NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table DROP_LOCATION 48 NULL YES nvarchar 255 510 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table DROPPED_EARLY 49 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table EXPENSES_TOTAL 50 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table EXTRA_PAY_RECEIVED 51 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table EXTRA_STOP_PICKUP_PAY 52 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table EQUIP_WASHING_COST 53 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table EQUIP_WASH_REIMBURSE 54 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FAX_COST 55 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FAX_REIMBURSEMENT 56 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_CARD_FEE_TOTAL 57 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FS_DIFF1_CALC 58 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FS_DIFF2_CALC 59 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FSA_DIFF1_CALC 60 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FSA_DIFF2_CALC 61 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_COST_AVG 62 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_PROFIT_LOSS 63 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_REIMBURSE_TOTAL 64 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_FAX 65 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_PAID 66 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_TRUCK 67 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_ADJ_TRUCK 68 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_ADJ_FAX 69 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_SUR_ADJ_PAID 70 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table FUEL_PURCHASED 71 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table GALS_PURCHASED 72 ((0)) YES decimal NULL NULL 7 10 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table INVOICE_NUMBER 73 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LH_DIFF1_CALC 74 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LH_DIFF2_CALC 75 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LINEHAUL_FAX 76 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LINEHAUL_PAID 77 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LINEHAUL_TRUCK 78 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_LOCKS 79 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_LOCK_REIMBURSE 80 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_NOTES 81 NULL YES nvarchar -1 -1 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_RELAY_OFF 82 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_RELAY_ON 83 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LOAD_RELAY_TRUCK 84 NULL YES nvarchar 10 20 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_ADDRESS 85 NULL YES nvarchar -1 -1 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_CONTACT 86 NULL YES nvarchar -1 -1 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_FEES 87 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_PHONE 88 NULL YES nvarchar 15 30 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_RECEIPT 89 NULL YES nvarchar 15 30 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_REIMBURSEMENT 90 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_SERVICE 91 NULL YES nvarchar -1 -1 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_SSN 92 NULL YES nvarchar 15 30 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table LUMPER_TAXID 93 NULL YES nvarchar 15 30 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table MULTI_STOP 94 NULL YES nvarchar 5 10 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table NUMB_DROPS 95 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table NUMB_PICKUPS 96 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table OUT_OF_POCKET_FUEL 97 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table OUT_OF_ROUTE_MILES 98 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table OSD 99 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table PALLET_COUNT 100 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PALLET_EXCHANGE 101 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PALLET_EXCHANGE_REIMBURSE 102 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PARKING 103 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PER_MILE_RATE_TRUCK 104 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PER_MILE_RATE_FAX 105 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PER_MILE_RATE_PAID 106 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PETS_LOAD_NUMBER 107 ((0)) YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PIECE_COUNT 108 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PRODUCT 109 NULL YES nvarchar -1 -1 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table PROFIT_GRAND_TOTAL 110 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PROFIT_PER_MILE 111 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PU_CONFIRM 112 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table PU_DRP_TRLR_FEE 113 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PU_NUMBER 114 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table PM_DIFF1_CALC 115 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table PM_DIFF2_CALC 116 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RATE_ACTUAL 117 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RATE_NEGOTIATED 118 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RCVR_CITY_STATE 119 NULL YES nvarchar 255 510 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table RCVR_CODE 120 NULL YES nvarchar 10 20 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table RECIEVER_DATE 121 NULL YES datetime2 NULL NULL NULL NULL NULL 7 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RECIEVER_TIME 122 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RCVR_NAME 123 NULL YES nvarchar 255 510 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table RCVR_TIME 124 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table REEFER_FUEL_LVL 125 NULL YES nvarchar 10 20 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table REEFER_FUEL_PROFIT_LOSS 126 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REEFER_PURCHASED 127 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REEFER_REIMBURSEMENT 128 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REEFER_SETTING 129 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table REPAIR_CREDIT 130 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REV_TOTAL_DIFF 131 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REV_TOTAL_FAX 132 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REV_TOTAL_PAID 133 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table REV_TOTAL_TRUCK 134 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RFR_FUEL_SUR_FAX 135 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RFR_FUEL_SUR_PAID 136 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RFR_FUEL_SUR_TRUCK 137 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RFR_GALS_TOT 138 NULL YES decimal NULL NULL 5 10 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RFER_FUEL_TAX_REFUND 139 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RF_DIFF1_CALC 140 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table RF_DIFF2_CALC 141 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SCALES_COST 142 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SCALES_REIMBURMENT 143 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SCALE_WEIGHT 144 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SEAL 145 NULL YES nvarchar 30 60 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIP_CITY_STATE 146 NULL YES nvarchar 255 510 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIP_CODE 147 NULL YES nvarchar 10 20 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIP_DATE 148 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIP_NAME 149 NULL YES nvarchar 255 510 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIPPER_DATE 150 NULL YES datetime2 NULL NULL NULL NULL NULL 7 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIPPER_TIME 151 NULL YES datetime NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table SHIP_TIME 152 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TOLL_COST 153 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TOLL_REIMBURMENT 154 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TOTAL_DRIVEN_MILES 155 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TOTAL_MILES_DIFF_CALC 156 ((0)) YES numeric NULL NULL 5 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRACTOR_FUEL_TAX_REFUND 157 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_DROPPED 158 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_DROPPED_01 159 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_DROPPED_90 160 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_HOOKED_01 161 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_HOOKED_90 162 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_HOOKED 163 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRAILER_SHUTTLED 164 NULL YES nvarchar 12 24 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRANSFLO_DATE_TIME 165 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRANSFLO_NUMBER 166 NULL YES nvarchar 50 100 NULL NULL NULL NULL NULL NULL UNICODE NULL NULL SQL_Latin1_General_CP1_CI_AS NULL NULL NULL
PETS_Database dbo Load_Info_Table TRIP_END_MILES 167 ((0)) YES numeric NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRIP_MPG 168 ((0)) YES decimal NULL NULL 5 10 2 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRIP_START_MILES 169 ((0)) YES numeric NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRLR_SHUTTLE_PAY 170 NULL YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRUCK_FUEL_PROFIT_LOSS 171 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
PETS_Database dbo Load_Info_Table TRUCK_SUPPLIES 172 ((0)) YES money NULL NULL 19 10 4 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL