Fast, Consistent Way To Bulk Insert?

Oct 17, 2006

I'm looking for a way to insert 50k records into a SQL Server table, and need to get it done faster. right now using BULK INSERT takes 5-10 seconds, but faster would be better, and even better if it were a consistent amount of time.

I've heard of DTS but don't know quite how to use it - would be offer any performance gains? any clue what the bottleneck is for BULK INSERT? hard drive speed? amount of RAM (this was on a 512mb machine)? parsing the fields?

thanks for any ideas.

View 7 Replies

How Do You Use An Identity Column When Doing A Bulk Insert Using The Bulk Insert Task Editor

Apr 18, 2008

Hello,

I'm just learning SSIS and I've hit my first bump. I am doing a bulk import from a tab delimited text file to an empty sql table that has a Idendity column defined. How do I tell the bulk insert task to skip that column when inserting from the text file. If I remove the identity column it imports the data fine, but I want to create the indentity column in the table too.

Thanks.

View 8 Replies View Related

Bulk Insert Using Script And Not Bulk Insert Task

Nov 2, 2007

Does anyone know how to do a bulk insert using just the script task? I've been searching everyehere but can't seem to find a sample.

View 6 Replies View Related

Bulk Insert - Bulk Load Data Conversion Error

Jan 17, 2008

Im having some issues with bulk insert.

This is the table:

CREATE TABLE [dbo].[tmp_GA_status](

[GA_recno] [int] NOT NULL,

[GA_desc] [varchar](40) NULL

)

This is the file (unicode):
1|"test1"
2|"test2"
3|"test3"
4|"test4"
5|"test5"
6|"test6"
7|"test7"
8|"test8"

and this is the sql:

bulk insert tmp_GA_status from 'C: empTextDumpGA_status.dta'

with (CODEPAGE='RAW', FIELDTERMINATOR='|', ROWTERMINATOR='
', DATAFILETYPE='widechar')

so yeah, pretty simple. But whatever I do I get this;

Msg 4864, Level 16, State 1, Line 1

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 2 (GA_desc).

So what am I doing wrong ?

View 13 Replies View Related

FAST Insert ?

Dec 18, 2007

I need to insert data to a temp table in SQL ,
I have

CREATE TABLE TMP_X (
doc_name varchar(200)
)

--select * from TMP_X

INSERT into TMP_X
values
(
'...,

but its saying there isn't a match, and i know why its trying to insert all the data as one row, but i need them as seperate rows as i want only 1 column..
is there another INSERT type function ?

View 2 Replies View Related

Fast Insert

Feb 14, 2008

If I have a table with one column
and i want to insert a few 100's rows of names
I can't use the INSERT stmt as that does one row at a time ,
how can i achieve this ?

View 5 Replies View Related

I Don't Suppose BULK UPDATE Exists?... Like BULK INSERT?

Sep 27, 2007

I have to update a field within a table of 60 records or so. Each record has a different field value. it's type varchar. i was given an excel file with the field values and was thinking of a bulk update like bulk insert, but i don't recall that it's possible that way.

Is the only way to create a table, bulk insert, then merge the two tables together with UPDATE?

Just wanted to see if there was an easier way to do it, otherwise i'll take the latter route. Thanks!

View 1 Replies View Related

Cannot Fetch A Row From OLE DB Provider BULK With Bulk Insert Task

Nov 23, 2005

Hi, folks:

View 18 Replies View Related

Loop For INSERT ? [ Fast Reply Please ]

Jun 23, 2008

Hi everyone
I want to know if it's possible to do a for/while-loop so i can use INSERT

Look:
I've this int [] test = new test[140];
But i need to insert for every value (140) a number
so normally it would be :
INSERT ... (case1, case2, case3 ...) value (test[1],test[2],test[3] ...)
But isn't there a way to it with a loop?
SOmething Like this ?

for( int i = 0 , i< 140, i++) {
INSERT case[i] value test[i]
}

Thanks in advance

Jonas

View 8 Replies View Related

Pros: How To Bulk Delete And Bulk Insert?

Oct 11, 2000

I have a table containing 8 million records.
I need to replace 2 million of these records with
a scaled down query that goes something like:
SELECT 1, ShareholderID, Assets1
FROM MyTable (Yields appx. 200,000 recods)
SELECT 2, ShareholderID, Assets2
FROM MyTable (Yields appx. 200,000 recods)
.
.
.
SELECT 10, ShareholderID, Assets1 + Assest2 + Assets3 + ... + Assets9
FROM MyTable (Yields appx. 200,000 recods)

Updates and cursors just seem to be too slow.

So far I have done the following, but was wondering if anyone could think of a better way.
SELECT 6 million records that don't need to be deleted into a #TempTable
Use statements above to select into same #TempTable
DROP and recreate Original Table
SELECT 6 + 2 million records INTO original table.

This seems rather convoluted. Is there a better approach? Would it be worth while to dump data to a file and use bcp / Bulk Insert

Any comments are appreciated,

-Marc

View 3 Replies View Related

OLE DB Destination - Fast Load With Maximum Insert Commit Size

Sep 8, 2006

I'm seeing some strange behavior from the OLE DB Destination when using the "fast load" access mode and setting the "Maximum insert commit size".

When I do not set the "Rows per batch" or the "Maximum insert commit size", the package I'm working with inserts 123,070 rows using a single "insert bulk" statement. The data seems to flow through the pipeline until it gets to the OLE DB Destination and then I see a short pause. I'm assuming the pause is from the "insert bulk" statement handling all of the rows at once.

When I set the "Rows per batch" option but leave the "Maximum insert commit size" alone, I generally see the same behavior -- a single "insert bulk" statement that handles all 123,070. In this case, however, the "insert bulk" statement has a "ROWS_PER_BATCH" option appended to the statement that matches the "Rows per batch" setting. This makes sense. I'm assuming the "insert bulk" then "batches" the rows into multiple insert statements (although I'm unsure of how to confirm this). This version of the "insert bulk" statement appears to run in about the same time as the case above.

When I set the "Maximum insert commit size" option and leave the "Rows per batch" statement alone, I see multiple "insert bulk" statements being executed, each handling the lower of either the value I specify for the "Maximum insert commit size" or the number of rows in a single buffer flowing through the pipeline. In my testing, the number of rows in a buffer was 9,681. So, if I set the "Maximum insert commit size" to 5,000, I see two "insert bulk" statements for each buffer that flows into the OLE DB Destination (one handling 5,000 rows and one handling 4,681 rows). If I set the "Maximum insert commit size" to 10,000, I see a single "insert bulk" statement for each buffer that flows into the OLE DB Destination (handling 9,681 rows).

Now the problem. When I set the "Maximum insert commit size" as described in the last case above, I see LONG pauses between buffers being handled by the OLE DB Destination. For example, I might see one buffer of data flow through (and be handled by one or more "insert bulk" statements based on the "Maximum insert commit size" setting), then see a 2-3 minute pause before the next buffer of data is handled (with its one or more "insert bulk" statements being executed). Then I might see a 4-5 minute pause before the next buffer of data is handled. The pause between the buffers being passed through the OLE DB Destination (and handled via the "insert bulk" statements) is sometimes shorter, sometimes longer.

Using Profiler, I don't see any other activity going on within the database or within SQL Server itself that would explain the pauses between the buffers being handled by the OLE DB Destination and the resulting "insert bulk" statements...

Can anyone explain what is going on here? Is setting the "Maximum insert commit size" a bad idea? What are the differences between it and the "Rows per batch" setting and what are the recommended uses of these two options to try to improve the performance of the insert (particularly when handling millions of rows)?

TIA for any thoughts or information...

Dave Fackler

View 8 Replies View Related

Error: 0xC002F304 At Bulk Insert Task, Bulk Insert Task: An Error Occurred With The Following Error Message: Cannot Fetch A Row

Apr 8, 2008

I receive the following error message when I try to use the Bulk Insert Task to load BCP data into a table:

Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 4. Verify that the field terminator and row terminator are specified correctly.Bulk load data conversion error (overflow) for row 1, column 1 (rowno).".

Task failed: Bulk Insert Task

In SSMS I am able to issue the following command and the data loads into a TableName table with no error messages:
BULK INSERT TableName
FROM 'C:DataDbTableName.bcp'
WITH (DATAFILETYPE='widenative');

What configuration is required for the Bulk Insert Task in SSIS to make the data load? BTW - the TableName.bcp file is bulk copy file as bcp widenative data type. The properties of the Bulk Insert Task are the following:
DataFileType: DTSBulkInsert_DataFileType_WideNative
RowTerminator: {CR}{LF}

Any help getting the bcp file to load would be appreciated. Let me know if you require any other information, thanks for all your help.
Paul

View 1 Replies View Related

BULK INSERT ERROR Using Format File - Bulk Load Data Conversion Error

Jun 29, 2015

I'm trying to use Bulk insert for the first time and getting the following error. I think it might have something to do with my Format File and from the error msg there's a conversion error for the first column. In my database the Field is nvarchar(6) so my best guess is to use SQLNChar for the first column. I've checked the end of each line is CR LF therefore the is correct for line 7 right?

Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 1, column 1 (ASXCode).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

BULK
INSERTtbl_ASX_Data_temp
FROM
'M:DataASXImportTest.txt'
WITH
(FORMATFILE='M:DataASXSQLFormatImport.Fmt')

[code]...

View 5 Replies View Related

Questions About Bulk Copy Insert Using 'Memory Based Bulk Copy Operations'

Feb 1, 2007

Hi~,

Before implementing memory based bulk copy insert with IRowsetFastLoad interface of SQL Server 2005 OLE DB provider, I want to know some considerations.

- performance : compared with T-SQL's "BULK INSERT ..." and bcp utility

- SQL Server's resource usage : when running memory based bulk copy, server resource's influence

- server side action(behavior) : when server is busy, delayed-update means IRowsetFastLoad::Commit(true) method can insert right after?

- row-count : The rowcount limitation can be inserted by IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit

- any other guide lines

View 1 Replies View Related

Can I Insert/Update Large Text Field To Database Without Bulk Insert?

Nov 14, 2007

I have a web form with a text field that needs to take in as much as the user decides to type and insert it into an nvarchar(max) field in the database behind. I've tried using the new .write() method in my update statement, but it cuts off the text after a while. Is there a way to insert/update in SQL 2005 this without resorting to Bulk Insert? It bloats the transaction log and turning the logging off requires a call to sp_dboptions (or a straight-up ALTER DATABASE), which I'd like to avoid if I can.

View 6 Replies View Related

How To Insert Data From A File Into Table Having Two Columns-BULK INSERT

Oct 12, 2007

Hi,
i have a file which consists data as below,

3
123||
456||
789||

Iam reading file using bulk insert and iam inserting these phone numbers into table having one column as below.

BULK INSERT TABLE_NAME FROM 'FILE_PATH'
WITH (KEEPNULLS,FIRSTROW=2,ROWTERMINATOR = '||')

but i want to insert the data into table having two columns. if iam trying to insert the data into table having two columns its not inserting.

can anyone help me how to do this?

Thanks,
-Badri

View 5 Replies View Related

TempDB , Consistent Connection

Sep 12, 2005

In MSSQL2000 I want to know how to make a user have a constant connection even if the the Server restarts . Im aware that tempDB clears itself everytime the server restarts, but still wanna know if i can have users/applicaitons connected even though the server restarts

View 4 Replies View Related

Data Corruption Consistent

Jun 13, 2007

Hi paul,
Can you help me solve this issue? I do backups everyday.
Do you think dropping and restoring the DB will solve this issue?

---------------------------------------------------------------------

DBCC results for 'dyacovel_db'.
DBCC results for 'sysobjects'.
There are 1044 rows in 20 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 5182 rows in 305 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 16780 rows in 499 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 659 rows in 296 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 67 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 23 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 9692 rows in 57 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'Luc_47Skus_Top100_Order_Counts'.
There are 45 rows in 1 pages for object 'Luc_47Skus_Top100_Order_Counts'.
DBCC results for 'DOMB_1MM'.
There are 0 rows in 1 pages for object 'DOMB_1MM'.
DBCC results for 'PROD_COMP_PROD2'.
There are 39218 rows in 405 pages for object 'PROD_COMP_PROD2'.
DBCC results for 'ST_DATE'.
There are 1 rows in 1 pages for object 'ST_DATE'.
DBCC results for 'Currency_CAD_to_USD_2004_2005'.
There are 731 rows in 2 pages for object 'Currency_CAD_to_USD_2004_2005'.
DBCC results for 'DOMB_1MW'.
There are 0 rows in 1 pages for object 'DOMB_1MW'.
DBCC results for 'DW_INVENTORY_COFILLRATEFULL'.
There are 58963 rows in 1235 pages for object 'DW_INVENTORY_COFILLRATEFULL'.
DBCC results for 'ST_MASTER_LOOP'.
There are 0 rows in 962 pages for object 'ST_MASTER_LOOP'.
DBCC results for 'DOMC1_PICK_TYPE'.
There are 158562 rows in 2742 pages for object 'DOMC1_PICK_TYPE'.
DBCC results for 'ml_xpdex_final_sold_rev'.
There are 66 rows in 1 pages for object 'ml_xpdex_final_sold_rev'.
DBCC results for 'temp_jumbo'.
There are 494973 rows in 14559 pages for object 'temp_jumbo'.
DBCC results for 'DOMB_1RK'.
There are 0 rows in 1 pages for object 'DOMB_1RK'.
DBCC results for 'michaelfor007'.
There are 2189 rows in 23 pages for object 'michaelfor007'.
DBCC results for 'SW_ORDER_FILLRATE_DL'.
There are 704131 rows in 42479 pages for object 'SW_ORDER_FILLRATE_DL'.
DBCC results for 'Sales_History_2005'.
There are 706373 rows in 141280 pages for object 'Sales_History_2005'.
DBCC results for 'DOMB_1RL'.
There are 0 rows in 1 pages for object 'DOMB_1RL'.
DBCC results for 'SOLD_SKUS_DL'.
There are 543293 rows in 1740 pages for object 'SOLD_SKUS_DL'.
DBCC results for 'DOMB_OUT'.
There are 317 rows in 16 pages for object 'DOMB_OUT'.
DBCC results for 'DOMC_PICK_TYPE'.
There are 158525 rows in 2791 pages for object 'DOMC_PICK_TYPE'.
DBCC results for 'DOMB_1TF'.
There are 0 rows in 1 pages for object 'DOMB_1TF'.
DBCC results for 'LUC_DAILY_FLASH_SALES_60DAYS'.
There are 13100 rows in 252 pages for object 'LUC_DAILY_FLASH_SALES_60DAYS'.
DBCC results for 'weekly_subclass_TOP10'.
There are 263 rows in 8 pages for object 'weekly_subclass_TOP10'.
DBCC results for 'DW_COFILLRATE_DL_PM'.
There are 80 rows in 3 pages for object 'DW_COFILLRATE_DL_PM'.
DBCC results for 'CURRENCY_CAD_USD'.
There are 701 rows in 7 pages for object 'CURRENCY_CAD_USD'.
DBCC results for 'LUC_SALES_ORDERDETAIL_2004'.
There are 688727 rows in 27611 pages for object 'LUC_SALES_ORDERDETAIL_2004'.
DBCC results for 'WEEKLYS_SUBCLASS_SALESly'.
There are 269906 rows in 8188 pages for object 'WEEKLYS_SUBCLASS_SALESly'.
DBCC results for 'Luc_47Skus_Top100_Step1'.
There are 3597 rows in 164 pages for object 'Luc_47Skus_Top100_Step1'.
DBCC results for 'DOMB_1TU'.
There are 0 rows in 1 pages for object 'DOMB_1TU'.
DBCC results for 'PROD_COMP_SKULIST'.
There are 12219 rows in 121 pages for object 'PROD_COMP_SKULIST'.
DBCC results for 'LUC_DAILY_FLASH_SALES_YESTERDAY'.
There are 326 rows in 8 pages for object 'LUC_DAILY_FLASH_SALES_YESTERDAY'.
DBCC results for 'WEEKLY_SUBCLASS_TOP20QTD'.
There are 290 rows in 10 pages for object 'WEEKLY_SUBCLASS_TOP20QTD'.
DBCC results for 'CO_DTL_DL_CA'.
There are 554 rows in 14 pages for object 'CO_DTL_DL_CA'.
DBCC results for 'DOMD1_PICK_TYPE'.
There are 158783 rows in 2895 pages for object 'DOMD1_PICK_TYPE'.
DBCC results for 'LUC_INVOICEDETAIL_2004'.
There are 732349 rows in 61395 pages for object 'LUC_INVOICEDETAIL_2004'.
DBCC results for 'DOMB_1W1'.
There are 0 rows in 1 pages for object 'DOMB_1W1'.
DBCC results for 'LUC_DAILY_FLASH_SALES_WEEKEND'.
There are 0 rows in 13 pages for object 'LUC_DAILY_FLASH_SALES_WEEKEND'.
DBCC results for 'Sales_Hist_Part_2004'.
There are 722121 rows in 144430 pages for object 'Sales_Hist_Part_2004'.
DBCC results for 'Luc_47Skus_Top100_Sku_Avgcost_Step1'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_Avgcost_Step1'.
DBCC results for 'swidziun.victory$'.
There are 492 rows in 8 pages for object 'swidziun.victory$'.
DBCC results for 'DOMB_1W4'.
There are 0 rows in 1 pages for object 'DOMB_1W4'.
DBCC results for 'mlehn.MLEHN_675_ADDRESS'.
There are 642 rows in 3 pages for object 'mlehn.MLEHN_675_ADDRESS'.
DBCC results for 'weekly_subclass_TOP10_RESALE'.
There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_RESALE'.
DBCC results for 'cradtke.cr_intl_test2'.
There are 28062 rows in 939 pages for object 'cradtke.cr_intl_test2'.
DBCC results for 'Sales_History_2004'.
There are 722121 rows in 144431 pages for object 'Sales_History_2004'.
DBCC results for 'Weekly_Subclass_Forecast'.
There are 2652 rows in 51 pages for object 'Weekly_Subclass_Forecast'.
DBCC results for 'DOMB_1W5'.
There are 0 rows in 1 pages for object 'DOMB_1W5'.
DBCC results for 'ML_675_ADDR_MISS'.
There are 24 rows in 2 pages for object 'ML_675_ADDR_MISS'.
DBCC results for 'swidziun.UPLOAD$'.
There are 40 rows in 1 pages for object 'swidziun.UPLOAD$'.
DBCC results for 'DOM_BOL_S1'.
There are 366531 rows in 10488 pages for object 'DOM_BOL_S1'.
DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED'.
There are 94017 rows in 2946 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED'.
DBCC results for 'SW_DS_BOOKED_ECP_PRISM_FINAL'.
There are 8 rows in 2 pages for object 'SW_DS_BOOKED_ECP_PRISM_FINAL'.
DBCC results for 'DOMB_SUMRRATE'.
There are 0 rows in 1 pages for object 'DOMB_SUMRRATE'.
DBCC results for 'mlehn.MLEHN_925_ADDRESS'.
There are 642 rows in 3 pages for object 'mlehn.MLEHN_925_ADDRESS'.
DBCC results for 'DANVILLE_TO_OUT'.
There are 10570 rows in 183 pages for object 'DANVILLE_TO_OUT'.
DBCC results for 'ECP_MARKET_SEGMENTS'.
There are 40 rows in 1 pages for object 'ECP_MARKET_SEGMENTS'.
DBCC results for 'Luc_47Skus_Top100_Sku_AvgCost'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Sku_AvgCost'.
DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'.
There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM_FINAL'.
DBCC results for 'DOMB_1TN'.
There are 0 rows in 1 pages for object 'DOMB_1TN'.
DBCC results for 'ML_925_ADDR_MISS'.
There are 88 rows in 4 pages for object 'ML_925_ADDR_MISS'.
DBCC results for 'weekly_subclass_TOP10_ALL'.
There are 20 rows in 1 pages for object 'weekly_subclass_TOP10_ALL'.
DBCC results for 'SW_DS_MTD_ECP_PRISM_FINAL'.
There are 10 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_Cancellation'.
There are 15991 rows in 799 pages for object 'Weekly_Subclass_Cancellation'.
DBCC results for 'ML_FAX_PMT_par'.
There are 6785 rows in 108 pages for object 'ML_FAX_PMT_par'.
DBCC results for 'LUC_ADHOC_SUBCLASS_04'.
There are 132823 rows in 4585 pages for object 'LUC_ADHOC_SUBCLASS_04'.
DBCC results for 'SALES_YESTERDAY'.
There are 1738 rows in 290 pages for object 'SALES_YESTERDAY'.
DBCC results for 'Luc_Top20_Invoices_Units_Step1'.
There are 123944 rows in 3756 pages for object 'Luc_Top20_Invoices_Units_Step1'.
DBCC results for 'SW_DS_BACKLOG1_ECP_PRISM'.
There are 224 rows in 4 pages for object 'SW_DS_BACKLOG1_ECP_PRISM'.
DBCC results for 'FREIGHT_FOR68'.
There are 16 rows in 1 pages for object 'FREIGHT_FOR68'.
DBCC results for 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'.
There are 8806 rows in 152 pages for object 'WEEKLY_SUBCLASS_BF_GBOOKED_FINAL'.
DBCC results for 'DOMB_LOWEST_SUM_RATE'.
There are 0 rows in 1 pages for object 'DOMB_LOWEST_SUM_RATE'.
DBCC results for 'ML_FAX_FG09_Fg10_final'.
There are 444 rows in 6 pages for object 'ML_FAX_FG09_Fg10_final'.
DBCC results for 'DOMB_1CI'.
There are 0 rows in 1 pages for object 'DOMB_1CI'.
DBCC results for 'temp_stan_cost_m2_lb'.
There are 181694 rows in 1932 pages for object 'temp_stan_cost_m2_lb'.
DBCC results for 'ml_FAX_pmt_par_FINAL'.
There are 615 rows in 7 pages for object 'ml_FAX_pmt_par_FINAL'.
DBCC results for 'SALES_DATA_2006_2007'.
There are 0 rows in 1 pages for object 'SALES_DATA_2006_2007'.
DBCC results for 'Weekly_Sales_Sublcass_top20_bookings'.
There are 283 rows in 8 pages for object 'Weekly_Sales_Sublcass_top20_bookings'.
DBCC results for 'SALES2006_REPORT_1'.
There are 558623 rows in 13303 pages for object 'SALES2006_REPORT_1'.
DBCC results for 'DANVILLE_TO_RDCW1'.
There are 249 rows in 5 pages for object 'DANVILLE_TO_RDCW1'.
DBCC results for 'Luc_Top20_Invoices_Units_Step2'.
There are 123944 rows in 4274 pages for object 'Luc_Top20_Invoices_Units_Step2'.
DBCC results for 'SW_DS_BACKLOG_ECP_PRISM'.
There are 10 rows in 2 pages for object 'SW_DS_BACKLOG_ECP_PRISM'.
DBCC results for 'cr_expense_data'.
There are 74184 rows in 5268 pages for object 'cr_expense_data'.
DBCC results for 'SW_DS_MTDLY_ECP_PRISM_FINAL'.
There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_Cancellation_Sum'.
There are 622 rows in 12 pages for object 'Weekly_Subclass_Cancellation_Sum'.
DBCC results for 'mlehn.MLEHN_PMT_ADDRESS'.
There are 63 rows in 1 pages for object 'mlehn.MLEHN_PMT_ADDRESS'.
DBCC results for 'weekly_sale_lytop20qtd'.
There are 293 rows in 10 pages for object 'weekly_sale_lytop20qtd'.
DBCC results for 'SW_FOR10'.
There are 100085 rows in 1934 pages for object 'SW_FOR10'.
DBCC results for 'Luc_top20_Invoices_Units_Step3'.
There are 29017 rows in 1382 pages for object 'Luc_top20_Invoices_Units_Step3'.
DBCC results for 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'.
There are 6 rows in 2 pages for object 'SW_DS_YESTERDAYS_SALE_ECP_PRISM'.
DBCC results for 'SW_DS_QTD_ECP_PRISM_FINAL'.
There are 12 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM_FINAL'.
DBCC results for 'ML_FAX_FG09_Fg10'.
There are 3587 rows in 54 pages for object 'ML_FAX_FG09_Fg10'.
DBCC results for 'DOMC_MASTERRATER'.
There are 1593 rows in 35 pages for object 'DOMC_MASTERRATER'.
DBCC results for 'DOM_BOL_S16A'.
There are 13785 rows in 657 pages for object 'DOM_BOL_S16A'.
DBCC results for 'DOMB_LOCATIONS'.
There are 15 rows in 1 pages for object 'DOMB_LOCATIONS'.
DBCC results for 'ML_PMT_ADDR_MISS'.
There are 126 rows in 5 pages for object 'ML_PMT_ADDR_MISS'.
DBCC results for 'LEmond.Danville_Rancho$'.
There are 191 rows in 17 pages for object 'LEmond.Danville_Rancho$'.
DBCC results for 'Luc_Top20_Invoices_Units_Sum_Total'.
There are 20 rows in 1 pages for object 'Luc_Top20_Invoices_Units_Sum_Total'.
DBCC results for 'SW_DS_MTD_ECP_PRISM'.
There are 11 rows in 2 pages for object 'SW_DS_MTD_ECP_PRISM'.
DBCC results for 'SW_DS_QTDLY_ECP_PRISM_FINAL'.
There are 10 rows in 1 pages for object 'SW_DS_QTDLY_ECP_PRISM_FINAL'.
DBCC results for 'TEMP_W4'.
There are 307 rows in 10 pages for object 'TEMP_W4'.
DBCC results for 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'.
There are 81232 rows in 5084 pages for object 'LUC_DAILY_FLASH_BOOKED_NET_SUM_60DAYS'.
DBCC results for 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'.
There are 3315 rows in 30 pages for object 'Weekly_Sales_Sublcass_top20_CANCELLATIONS'.
DBCC results for 'DOM_BOL_S16B'.
There are 13785 rows in 657 pages for object 'DOM_BOL_S16B'.
DBCC results for 'VP_DETAIL_DL_TEMP'.
There are 67047 rows in 988 pages for object 'VP_DETAIL_DL_TEMP'.
DBCC results for 'DOM_JUMBO_BOL_TOT'.
There are 92 rows in 1 pages for object 'DOM_JUMBO_BOL_TOT'.
DBCC results for 'ML_FAX_ALL'.
There are 14999 rows in 256 pages for object 'ML_FAX_ALL'.
DBCC results for 'Luc_Top20_Report'.
There are 20 rows in 1 pages for object 'Luc_Top20_Report'.
DBCC results for 'SW_DS_MTDLY_ECP_PRISM'.
There are 10 rows in 2 pages for object 'SW_DS_MTDLY_ECP_PRISM'.
DBCC results for 'SW_DS_YTD_ECP_PRISM_FINAL'.
There are 12 rows in 2 pages for object 'SW_DS_YTD_ECP_PRISM_FINAL'.
DBCC results for 'TEMP_W41'.
There are 446 rows in 14 pages for object 'TEMP_W41'.
DBCC results for 'DOMC_WHSE_RANK'.
There are 1 rows in 1 pages for object 'DOMC_WHSE_RANK'.
DBCC results for 'WEEKLY_SUBCLASS_CANCEL_CHART'.
There are 432 rows in 4 pages for object 'WEEKLY_SUBCLASS_CANCEL_CHART'.
DBCC results for 'FPR101_Compare_Report'.
There are 68426 rows in 22814 pages for object 'FPR101_Compare_Report'.
DBCC results for 'RM_JANUARY_2007'.
There are 7563 rows in 281 pages for object 'RM_JANUARY_2007'.
DBCC results for 'WEEKLY_SUBCLASS_BF_CAN'.
There are 2343 rows in 18 pages for object 'WEEKLY_SUBCLASS_BF_CAN'.
DBCC results for 'SW_DS_YTDLY_ECP_PRISM_FINAL'.
There are 11 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM_FINAL'.
DBCC results for 'Weekly_Subclass_SalesChart'.
There are 224 rows in 5 pages for object 'Weekly_Subclass_SalesChart'.
DBCC results for 'FPR101_Compare_Report_Final'.
There are 68426 rows in 9885 pages for object 'FPR101_Compare_Report_Final'.
DBCC results for 'ML_FAX_aLL_final'.
There are 231 rows in 7 pages for object 'ML_FAX_aLL_final'.
DBCC results for 'Temp_Booking_dl'.
There are 166084 rows in 6681 pages for object 'Temp_Booking_dl'.
DBCC results for 'TEMP_W411'.
There are 454 rows in 15 pages for object 'TEMP_W411'.
DBCC results for 'Value_Test_Freight_Data1_BolSum'.
There are 51332 rows in 634 pages for object 'Value_Test_Freight_Data1_BolSum'.
DBCC results for 'Archive_Holds'.
There are 9182 rows in 185 pages for object 'Archive_Holds'.
DBCC results for 'TOP100_EDI'.
There are 100 rows in 4 pages for object 'TOP100_EDI'.
DBCC results for 'FREIGHT_FOR13_AVG_DISC'.
There are 1 rows in 1 pages for object 'FREIGHT_FOR13_AVG_DISC'.
DBCC results for 'LUC_ADHOC_SUBCLASS_04_Open'.
There are 689 rows in 28 pages for object 'LUC_ADHOC_SUBCLASS_04_Open'.
DBCC results for 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'.
There are 83792 rows in 11976 pages for object 'FPR101_COMPARE_REPORT_FINAL_ARCHIVE'.
DBCC results for 'LUC_adhoc_joe'.
There are 84643 rows in 1924 pages for object 'LUC_adhoc_joe'.
DBCC results for 'TEMP_W5'.
There are 5814 rows in 183 pages for object 'TEMP_W5'.
DBCC results for 'DW_Sales2006'.
There are 299 rows in 2 pages for object 'DW_Sales2006'.
DBCC results for 'INVENTORY_SUM'.
There are 209426 rows in 2411 pages for object 'INVENTORY_SUM'.
DBCC results for 'ORDERS_CODE9'.
There are 453 rows in 17 pages for object 'ORDERS_CODE9'.
DBCC results for 'SKU_ABC'.
There are 17627 rows in 114 pages for object 'SKU_ABC'.
DBCC results for 'Sales_History_2007'.
There are 230381 rows in 46083 pages for object 'Sales_History_2007'.
DBCC results for 'DOM_BOL_s5rk'.
There are 367500 rows in 8971 pages for object 'DOM_BOL_s5rk'.
DBCC results for 'RM_DECEMBER_2006'.
There are 7262 rows in 269 pages for object 'RM_DECEMBER_2006'.
DBCC results for 'DW_INVENTORY_AVAILABILITY'.
There are 37253 rows in 217 pages for object 'DW_INVENTORY_AVAILABILITY'.
DBCC results for 'temp_prod'.
There are 29640 rows in 682 pages for object 'temp_prod'.
DBCC results for 'Weekly_Subclass_Booking_Sum'.
There are 391 rows in 11 pages for object 'Weekly_Subclass_Booking_Sum'.
DBCC results for 'DOMC_BOL_FREIGHTCALC'.
There are 1 rows in 1 pages for object 'DOMC_BOL_FREIGHTCALC'.
DBCC results for 'INVENTORY_CANADIAN_LOCS'.
There are 44 rows in 1 pages for object 'INVENTORY_CANADIAN_LOCS'.
DBCC results for 'TEMP_SALES_2004_2007'.
There are 391800 rows in 17811 pages for object 'TEMP_SALES_2004_2007'.
DBCC results for 'FREIGHT_MINCHG'.
There are 1 rows in 1 pages for object 'FREIGHT_MINCHG'.
DBCC results for 'LUC_DAILY_FLASH_CANCEL'.
There are 20882 rows in 280 pages for object 'LUC_DAILY_FLASH_CANCEL'.
DBCC results for 'FRM10'.
There are 183488 rows in 6335 pages for object 'FRM10'.
DBCC results for 'DOMB_NUMDAYS'.
There are 1 rows in 1 pages for object 'DOMB_NUMDAYS'.
DBCC results for 'FREIGHT_WHSE'.
There are 15 rows in 1 pages for object 'FREIGHT_WHSE'.
DBCC results for 'SW_DS_QTDLY_ECP_PRISM'.
There are 11 rows in 2 pages for object 'SW_DS_QTDLY_ECP_PRISM'.
DBCC results for 'ml_cancel_dollar_reason_desc'.
There are 1723 rows in 31 pages for object 'ml_cancel_dollar_reason_desc'.
DBCC results for 'Temp_can_dl'.
There are 7530 rows in 163 pages for object 'Temp_can_dl'.
DBCC results for 'mlehn.MLEHN_FG09_FG10_ADDRESS'.
There are 643 rows in 3 pages for object 'mlehn.MLEHN_FG09_FG10_ADDRESS'.
DBCC results for 'INVENTORY_CANADIAN_EXRATE'.
There are 1 rows in 1 pages for object 'INVENTORY_CANADIAN_EXRATE'.
DBCC results for 'Luc_Top20_Step1'.
There are 132991 rows in 2342 pages for object 'Luc_Top20_Step1'.
DBCC results for 'DOM_BOL_MAR'.
There are 122100 rows in 4218 pages for object 'DOM_BOL_MAR'.
DBCC results for 'cr_expense_group'.
There are 28 rows in 1 pages for object 'cr_expense_group'.
DBCC results for 'SHIPPING_INFO_SHELDON'.
There are 9706 rows in 157 pages for object 'SHIPPING_INFO_SHELDON'.
DBCC results for 'SW_DS_QTD_ECP_PRISM'.
There are 13 rows in 2 pages for object 'SW_DS_QTD_ECP_PRISM'.
DBCC results for 'Calendar_2007'.
There are 365 rows in 3 pages for object 'Calendar_2007'.
DBCC results for 'ML_fg09_fg10_ADDR_MISS'.
There are 2 rows in 1 pages for object 'ML_fg09_fg10_ADDR_MISS'.
DBCC results for 'LUC_Top20_Step2'.
There are 2465 rows in 42 pages for object 'LUC_Top20_Step2'.
DBCC results for 'LEmond.Sku_Top20$'.
There are 45 rows in 1 pages for object 'LEmond.Sku_Top20$'.
DBCC results for 'FDP05_all'.
There are 3714 rows in 39 pages for object 'FDP05_all'.
DBCC results for 'DOMB_DATES'.
There are 1 rows in 1 pages for object 'DOMB_DATES'.
DBCC results for 'LUC_DAILY_FLASH_INVENTORY'.
There are 9690641 rows in 364196 pages for object 'LUC_DAILY_FLASH_INVENTORY'.
DBCC results for 'DOM_BOL_S9W1'.
There are 367500 rows in 18388 pages for object 'DOM_BOL_S9W1'.
DBCC results for 'Orders_Code9_Report'.
There are 453 rows in 10 pages for object 'Orders_Code9_Report'.
DBCC results for 'SW_DS_YTD_ECP_PRISM'.
There are 13 rows in 1 pages for object 'SW_DS_YTD_ECP_PRISM'.
DBCC results for 'ML_XPDEX_Sold_to_prices'.
There are 0 rows in 1 pages for object 'ML_XPDEX_Sold_to_prices'.
DBCC results for 'cradtke.cr_sdm_inv'.
There are 14780 rows in 296 pages for object 'cradtke.cr_sdm_inv'.
DBCC results for 'cr_sdm_combined'.
There are 28296 rows in 838 pages for object 'cr_sdm_combined'.
DBCC results for 'Open_Orders_Status_10_Tape_Film'.
There are 3313 rows in 165 pages for object 'Open_Orders_Status_10_Tape_Film'.
DBCC results for 'LEmond.Luc_47Skus_Top100'.
There are 100 rows in 3 pages for object 'LEmond.Luc_47Skus_Top100'.
DBCC results for 'Open_Order_Pastdue_Report'.
There are 3008 rows in 150 pages for object 'Open_Order_Pastdue_Report'.
DBCC results for 'SW_DS_YTDLY_ECP_PRISM'.
There are 12 rows in 2 pages for object 'SW_DS_YTDLY_ECP_PRISM'.
DBCC results for 'SE_CUSTOMERS_M'.
There are 3 rows in 1 pages for object 'SE_CUSTOMERS_M'.
DBCC results for 'Open_Order_Report'.
There are 11686 rows in 532 pages for object 'Open_Order_Report'.
DBCC results for 'SW_DS_FINAL_SUM_ECP'.
There are 17 rows in 2 pages for object 'SW_DS_FINAL_SUM_ECP'.
DBCC results for 'TEST_bin'.
There are 2863 rows in 40 pages for object 'TEST_bin'.
DBCC results for 'SKU_AVGWGHTSUBC'.
There are 39 rows in 1 pages for object 'SKU_AVGWGHTSUBC'.
DBCC results for 'cr_sdm_item'.
There are 38065 rows in 1530 pages for object 'cr_sdm_item'.
DBCC results for 'Open_Schedules_Query'.
There are 2358 rows in 37 pages for object 'Open_Schedules_Query'.
DBCC results for 'cr_sdm_prodgrp_invsls'.
There are 23300 rows in 207 pages for object 'cr_sdm_prodgrp_invsls'.
DBCC results for 'Luc_47Skus_Top100_Skulist'.
There are 45 rows in 2 pages for object 'Luc_47Skus_Top100_Skulist'.
DBCC results for 'LJ_FISCAL_DATE'.
There are 1 rows in 1 pages for object 'LJ_FISCAL_DATE'.
DBCC results for 'LUC_DAILY_FLASH_CANCEL_SUM'.
There are 2827 rows in 222 pages for object 'LUC_DAILY_FLASH_CANCEL_SUM'.
DBCC results for 'temp_sh2'.
There are 171165 rows in 2063 pages for object 'temp_sh2'.
DBCC results for 'DOMA_INVENTORY'.
There are 23816 rows in 505 pages for object 'DOMA_INVENTORY'.
DBCC results for 'cr_sdm_orhdr'.
There are 19793 rows in 2234 pages for object 'cr_sdm_orhdr'.
DBCC results for 'SW_DS_YESTERDAY_FLEX'.
There are 7 rows in 2 pages for object 'SW_DS_YESTERDAY_FLEX'.
DBCC results for 'ML_CANCELLATION'.
There are 1495 rows in 61 pages for object 'ML_CANCELLATION'.
DBCC results for 'Sales_History_Driver'.
There are 816914 rows in 163383 pages for object 'Sales_History_Driver'.
DBCC results for 'SW_DS_BOOKED_ECP_PRISM'.
There are 8 rows in 1 pages for object 'SW_DS_BOOKED_ECP_PRISM'.
DBCC results for 'cr_sdm_ordet'.
There are 30303 rows in 2339 pages for object 'cr_sdm_ordet'.
DBCC results for 'SW_DS_MTD_FLEX'.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
There are 10 rows in 2 pages for object 'SW_DS_MTD_FLEX'.
DBCC results for 'Claim_Weekly'.
There are 18796 rows in 227 pages for object 'Claim_Weekly'.
DBCC results for 'LUC_APRIL2007'.
There are 4080 rows in 51 pages for object 'LUC_APRIL2007'.
DBCC results for 'DOMB_MINORDDATE'.
There are 1 rows in 1 pages for object 'DOMB_MINORDDATE'.
DBCC results for 'cr_openord_test'.
There are 1170 rows in 16 pages for object 'cr_openord_test'.
DBCC results for 'cr_sdm_cust1'.
There are 4417 rows in 108 pages for object 'cr_sdm_cust1'.
DBCC results for 'asp_data'.
There are 325752 rows in 23268 pages for object 'asp_data'.
DBCC results for 'ml_cancel_dollar'.
There are 731 rows in 7 pages for object 'ml_cancel_dollar'.
DBCC results for 'GERRY_APRIL_2007'.
There are 1915 rows in 37 pages for object 'GERRY_APRIL_2007'.
DBCC results for 'DOMA_INVENTORY_SUM'.
There are 7408 rows in 48 pages for object 'DOMA_INVENTORY_SUM'.
DBCC results for 'CLAIMS_AUDIT_TRAIL'.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 41. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 55. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 62. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 104. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 111. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 118. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764328), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 10. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 28. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 31. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 61. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764329), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764330), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764331), row 66. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764332), row 117. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 47. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 86. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764333), row 122. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 49. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 78. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764334), row 113. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 32. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764335), row 87. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764336), row 112. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 45. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764337), row 75. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 64. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 74. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 88. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764338), row 126. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 97. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764339), row 119. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764340), row 0. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 90. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764341), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 2. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764342), row 29. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 3. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 9. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 39. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 48. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 56. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 72. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 94. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 101. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 115. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764343), row 124. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 1. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 8. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 19. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 30. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 37. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 44. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 80. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 89. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764344), row 98. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 7. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 14. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 24. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 40. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 54. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 57. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 93. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764345), row 109. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 13. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 33. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 52. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 58. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 73. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 77. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 91. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 43, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 99. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 9.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 488705317, index ID 0, page (1:4764346), row 108. Record check (Valid SqlVariant) failed. Values are 6 and 0.
Server: Msg 2537, Level 16, State 1, Line

View 11 Replies View Related

Insert Trigger For Bulk Insert

Nov 25, 2006

In case of a bulk insert, the “FOR INSERT�? trigger fires for each recod or only once?
Thanks,

View 1 Replies View Related

Compare BULK INSERT Vs INSERT

Apr 26, 2006

Hello,
I am wondering is the Transaction Log logged differently between BULK INSERT vs INSERT? Performance speaking, which operations is generally faster given the same amout of data inserted.

Sincerely,
-Lawrence

View 3 Replies View Related

Questions About Memory Based Bulk Copy Operation(InsertRow Count,array Insert Directly,set Memory Based Bulk Copy Option)

Feb 15, 2007

Hi~, I have 3 questions about memory based bulk copy.

1. What is the limitation count of IRowsetFastLoad::InsertRow() method before IRowsetFastLoad::Commit(true)?
For example, how much insert row at below sample?(the max value of nCount)
for(i=0 ; i<nCount ; i++)
{
pIFastLoad->InsertRow(hAccessor, (void*)(&BulkData));
}

2. In above code sample, isn't there method of inserting prepared array at once directly(BulkData array, not for loop)

3. In OLE DB memory based bulk copy, what is the equivalent of below's T-SQL bulk copy option ?
BULK INSERT database_name.schema_name.table_name FROM 'data_file' WITH (ROWS_PER_BATCH = rows_per_batch, TABLOCK);

-------------------------------------------------------
My solution is like this. Is it correct?

// CoCreateInstance(...);
// Data source
// Create session

m_TableID.uName.pwszName = m_wszTableName;
m_TableID.eKind = DBKIND_NAME;

DBPROP rgProps[1];
DBPROPSET PropSet[1];

rgProps[0].dwOptions = DBPROPOPTIONS_REQUIRED;
rgProps[0].colid = DB_NULLID;
rgProps[0].vValue.vt = VT_BSTR;
rgProps[0].dwPropertyID = SSPROP_FASTLOADOPTIONS;
rgProps[0].vValue.bstrVal = L"ROWS_PER_BATCH = 10000,TABLOCK";

PropSet[0].rgProperties = rgProps;
PropSet[0].cProperties = 1;
PropSet[0].guidPropertySet = DBPROPSET_SQLSERVERROWSET;

if(m_pIOpenRowset)
{
if(FAILED(m_pIOpenRowset->OpenRowset(NULL,&m_TableID,NULL,IID_IRowsetFastLoad,1,PropSet,(LPUNKNOWN*)&m_pIRowsetFastLoad)))
{
return FALSE;
}
}
else
{
return FALSE;
}

View 6 Replies View Related

Do Not Keep NULLS Using SSIS Bulk Insert Task - Insert Empty Strings Instead Of NULLS

May 15, 2008

I have two SSIS packages that import from the same flat file into the same SQL 2005 table. I have one flat file connection (to a comma delimited file) and one OLE DB connection (to a SQL 2005 Database). Both packages use these same two Connection Managers. The SQL table allows NULL values for all fields. The flat file has "empty values" (i.e., ,"", ) for certain columns.

The first package uses the Data Flow Task with the "Keep nulls" property of the OLE DB Destination Editor unchecked. The columns in the source and destination are identically named thus the mapping is automatically assigned and is mapped based on ordinal position (which is equivalent to the mapping using Bulk Insert). When this task is executed no null values are inserted into the SQL table for the "empty values" from the flat file. Empty string values are inserted instead of NULL.

The second package uses the Bulk Insert Task with the "KeepNulls" property for the task (shown in the Properties pane when the task in selected in the Control Flow window) set to "False". When the task is executed NULL values are inserted into the SQL table for the "empty values" from the flat file.

So using the Data Flow Task " " (i.e., blank) is inserted. Using the Bulk Insert Task NULL is inserted (i.e., nothing is inserted, the field is skipped, the value for the record is omitted).

I want to have the exact same behavior on my data in the Bulk Insert Task as I do with the Data Flow Task.

Using the Bulk Insert Task, what must I do to have the Empty String values inserted into the SQL table where there is an "empty value" in the flat file? Why & how does this occur automatically in the Data Flow Task?

From a SQL Profile Trace comparison of the two methods I do not see where the syntax of the insert command nor the statements for the preceeding captured steps has dictated this change in the behavior of the inserted "" value for the recordset. Please help me understand what is going on here and how to accomplish this using the Bulk Insert Task.

View 2 Replies View Related

Maintain A Consistent DB Connection Through Application Lifecycle

Nov 10, 2006

Hey everyone, I'm new to .NET and I've recently inheirited a rather large and busy asp.net website. I was asked to add a testimonials section on each page that will randomly pull a testimonial out of the db. This is fine, however, I'm getting random errors about the DB connection either being closed or connecting. Here is the code for the testimonials class: 1 public SqlDataReader GetTestimonials(ref SqlDataReader reader, int iCatID, string sLanguageType)2 {3 SqlCommand cmd = new SqlCommand("sp_DVX_Testimonials_Fetch", Connection);4 cmd.CommandType = CommandType.StoredProcedure;5
6 cmd.Parameters.Add(new SqlParameter("@Cat_ID", iCatID));7 cmd.Parameters.Add(new SqlParameter("@LanguageType", sLanguageType));8
9 reader = cmd.ExecuteReader();10
11 return reader;12 } I know this isn't the best way to do this (especially for each page[this site averages about 1000 hits a day]), so I was wondering was--is there a way to maintain a single DB connection that's set up in the Application_Start that will maintain the connection so I don't have to worry about this error. If not, does anyone and any ideas as to what would help? Thanks in advance!

View 4 Replies View Related

The Value You Entered Is Not Consistent With The Data Type Of The Column.

Jun 6, 2005

Hi..

I am trying to add new record to any table in my database.
But I can't.

I am tryting to add a value (1500 character) and it gives the message below

"The value you entered is not consistent with the data type of the column."

I have tried alot.
The result is my columns in my table accept maximum 900 character.

But the type of my column I try to add a value is text..

I am too angry with SQL

Please help

View 10 Replies View Related

The Value You Entered Is Not Consistent With The Data Type Or Length Of The Column

Feb 3, 2001

I keep getting this error:

'The value you entered is not consistent with the data type or length of the column'

when trying to enter data into a feild, the feild type is char and the length
is 100 i'm entering text 3 words long but no where near a 100 characters long
any one know why this is happening?

View 1 Replies View Related

Bulk Insert

Oct 27, 2006

hi friends i am trying for bulk insert using SQL server 2000using this codebulk insert xyzfrom 'D:authors.txt'WITH (FIELDTERMINATOR = ',') but it gve me error saying thatCould not bulk insert because file 'D:authors.txt' could not be opened. Operating system error code 21(error not found). i check file securityit has given full control to the file can any one give me idea about Operating System error code 21(error not found) thanks

View 1 Replies View Related

Something Like A Bulk Insert...

Aug 28, 2007

Hi,I've a SP that insert records in one table and then call another insert SP on a second table. The first table is like a master table and the second is like a child table. After inserting the right record in the master table, I've to insert some record in the child table. This records differ each other only by two of about ten field, so what I'd want is not to call the second SP X times, but only one time.. Is it possible??ExampleTable1: Id (identity), Desc;Table2: Id (identity), Id_table1, Id_TableX, Num, Field1, Field2, ... Field10.In Table2 only Id_TableX and Num change every time... the other are all the same (for one record in Table1). How can I do? Probably with a bulk insert and a bulk update?? But, can I make a bulk xxx without a file??

View 3 Replies View Related

BULK INSERT

Dec 28, 2007

hi friends i am using bulk insert cmd using my table name but i am facing error.....SO
IS IT POSSIBLE TO USE BULK INSERT WITH TEMPRARY TABLE VARIABLE
PLZ HELP ME

View 2 Replies View Related

Bulk Insert ?

Dec 20, 2000

How can I do a bulk insert without the transaction being logged?

View 1 Replies View Related

Does DTS Do Bulk Insert?

Sep 15, 2000

Hi,

I want to move data from a text file to a SQL table. After DTS creates the table, does it use Bulk Insert to copy the data from the file to the table, or BCP?

Thanks,
Judith

View 2 Replies View Related

Bulk Insert

May 19, 2000

I am trying to do a bulk insert from a data file into a linked access database. When I run the query I get the error message:
'Server: Msg 4801, Level 16, State 81, Line 1
Bulk_main: The opentable system function on BULK INSERT table failed.
Not sure what the problem is because BOL just says to check Microsoft.com for updated error message information. However, when I went to the site there was no updated information. Has anyone else seen this error? If so, have you figured out the problem? Any help would be greatly appreciated. Thanks.

Jim

View 1 Replies View Related

Bulk Insert Vs BCP

Sep 12, 2000

Hi,

Which is a faster method -- bulk insert or BCP

And I assume DTS has no problem handling either one? The input files are between 400 meg and 1 gig.

Thanks,
Judith

View 3 Replies View Related

Bulk Insert ?

Dec 5, 2000

How does one perform a bulk insert?

View 1 Replies View Related