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 RepliesHey 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!
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
Hi, I have an SSIS project, has a connection to tempdb (local sql2k5 server), 3 tasks, creating a table, populating the table, then deleting the table. of course when I test the connection i GET TEST Succesfull (I amusing sa ...)
Whenever I run the package, all tasks become red colored indicating, I get the following error :
---------------------------------------------------------------------------------------------------------------------------
[Execute SQL Task] Error: Failed to acquire connection "tempdb".
connection may not be configured correctly or you may not have the right permissions on this connection.vance
----------------------------------------------------------------------------------------------------------------------------
Any help would be appreciated. Thanks in advance
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.
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
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?
In the 70-461 objectives it says: Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications...I think I understand what this means in general. They want us to be able to create a view that will still be able to call the original data even if the table is modified. In other words, the view table shouldn't easily be broken. ie, type a code that does NOT ensure non regression, then change the code so that it does ensure non regression.Â
View 4 Replies View RelatedHas anyone seen the SQL Server error:
"tempdb is skipped. You cannot run a query that requires tempdb"?
We're running a .Net web application with a SQL Server 2000 backend, and we get the error intermittently. Restarting the SQL Server service seems to fix it, as it causes tempdb to be rebuilt, but this isn't a long term solution. Any direction or hints would be greatly appreciated. Thanks!
- Mike
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
TempDB is one of the databases equipped with MSSQL Server by default.What is the purpose of it?Why do we use this temp database?
View 4 Replies View RelatedHi,
THis is sql server 6.5 question.
I have tempdb data device size default 2 MB, which has completely filled up. I am trying to expand data device to it.
I created new device tempdb_data_ext (250 MB) and tried to expand tempdb data device. But everytime I do it, it ends up adding space to tempdb log device. How can I expand tempdb data device?
It's extremely urgent.
Thanks
Hi,
How can I control the growth of tempdb in SQl server.It's growing like anything.
CAn I create some alerts or jobs and what those alerts/job are supposed to do?
All help appreciated.
Jai
Hello!
This is error message I discovered in NT even viewer:
c:MSSQL7DATATEMPDB.MDF: Operating system error 112(There is not enough space on the disk.) encountered.
In SQL Server error log the errors are:
Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth..
Currently tempdb rezides on C drive and it's almost out of space.
What should I do?
Detach tempdb and then move to different drive?
What's the procedure?
Thanks
Lena
TEMPDB in one of our production servers does not clear up so every three to four weeks I have to restart NT. Nothing like this happens on any of the other three servers. Does anybody know where I should look at to correct the problem. I sure would appreciate it.
Thanks
Shashu
I have never done this before and thought I would ask. Is it possible to detach the tempdb database, move it to another drive or partition, and then re-attach it? What would be the downside or side-affects to doing such a thing?
Thanks. JT
We want to shrink the size of our TEMPDB , Does anyone know how to without blowing it away and re creating it.
Also, our tempdb expands to occupy all available space on the server, the space is not released until the server is restarted.
Any ideas would be appreciated.
Hi why I cannot backup the tempdb. Is this a normal or there is something that I am doing wrong.
Ali
Hi
I get a message:
Error : 933, Severity: 22, State: 1
Logical page 258 of the log encountered while retrieving highest timestamp in database 'tempdb' is not the last page of the log and we are not currently recovering that database.
I use sqlserver -T4022 to start my SQL Server since it will not start with out it. When I start sqlserver without the option, it tells me that
Error : 615, Severity: 21, State: 1
Unable to find database table id = 2, name = 'tempdb'.
I just want my SQL Server back. Please help!
Thanks
Betty Lee
I need to move tempdb to another drive,also increase the size.Largest database is 15GB.Can anyone suggest the size and also the exact commands to move.Do I need to backup the databases before I do this task?If SP1 is not installed,will it be o.k for me for this tempdb problem.If we have a larger tempdb like 4GB,will it effect anything?...Urgent!!
View 2 Replies View RelatedThe tempdb has grown to over 2 GB on our DB. There are no user tables or SP in it. Is there a way to clean up and are there any consequences to this?
View 4 Replies View RelatedI read an article on this site by Michael Hotek re "Basic SQL Server 6.5 Configuration Options". In the paragraph about TempDB he says that you should always avoid using Temp tables in stored procs. I use this feature a lot when trying to do "not in" type queries (I filter out a portion of a larger table and then use the "not in" on the temp table rather than the entire table.)
Is there a better way to run a Not in query. I have the table well indexed (i think) but it seems to do a full table scan if I use the entire table.
Any ideas???
Our Tempdb.mdf file is 11 gigs. I have tried several things to shrink this but with no luck. Does anybody have a suggestion on how I can free up that space. I have tried to re-start Sql but that didn't do anything. I thought that there was a bug, if the files got above 4 gig that sql wouldn't clear them, but I could be wrong
I thought I could detach it, and attach a new file, but makes me nervous without knowing if that’s correct.
Thanks for the help
Hi,
I moved my tempdb (2MB) to RAM and restarted the server. It did restart but when I tried to connect thru ISQL, it gave me an ERROR -
A connection could not be established to <server-name> - DB-Library. Unable to Connect.
What could be the possible reason.
To move tempdb to RAM, do i just have to change the values of the MEMORY and TEMPDB IN RAM parms and restart or do I have to do anything else.
Please help.
Thanks
Nishant
Hi
When should I put tempdb in RAM and when should I not ?
Thanks in advance
Vijay
I am trying to configure a 6.5 server to set the tempdb to run off disk. I reset the tempdb in ram = 0 in the configuration, and restarted the service, but it left it as running in ram, with 0 configured. I then rebooted the server, and it still left the tempdb in ram. Any ideas?
View 2 Replies View RelatedHi All,
I am trying to get some information about tempdb database. I've tried BOL but I couldn't find a whole lot of info. I am trying to find out what size should tempdb be to not to cause problems. Also, I am trying to shrink tempdb by using shrink database option in EM, but it only shrinks the tempdb transaction log not the datafile, and I don't know why it is happening.
Thanks
We are using Peoplesoft HRMS version 7.0 on NT Server 4.0 and SQL Server 6.5, service packs on both up-to-date.
The server is a HP LX Pro with 4 200 MHz 1MB cache processors with 2,560 MB of RAM and 18 9GB drives configured with different combinations of RAID 1, 1+0, and 5.
The database is 2.3GB in actual size with the specific size of 6GB for data and 2GB for log on separate RAIDs.
We would like to use tempdb in RAM to boost the speed of complex queries that use the tempdb for intermediate working tables.
We would like to know of any experience of running tempdb in RAM, issues to overcome, of how to setup.
There are articles and books not recommending using tempdb in RAM. Comments anyone?
Note: Have looked in SQL Server DBA Survival Guide, and SQL Server Unleashed, along with the normal MS Documentation, technet, online books, and knowledge base searches.
System: Pentium II - Dual 450. 13 GIG RAID. 128 MB RAM.
Everything I've ever heard or seen says not to put tempDB in RAM, citing reasons of negligible benefit or even worse performance as it steals memory from SQL's cache memory.
My issue is I need to take anywhere from 500 to 3000 records (games played) in a batch every five minutes from a table, ordered by game id. There's no guarantee of sequential order to how the records are inserted, so I need to do an ORDER BY in my query. I also do a stored procedure for ranking that requires an ORDER BY.
The performance difference between the two is staggering. 1000 records with a 200 mb tempdb database (not in RAM) takes about 300 seconds. With a 16 MB tempdb database IN ram, it takes just under 127 seconds. Only problem? I'm constantly getting, after a few batches have run, "out of space in syslogs for tempdb ram messages. "
Is there a way to net such performance from tempdb without putting it in RAM, and if not, is there a way to explicity clear out tempdb. Thanks for any help.
Hello All~
I have a problem with Tempdb database on SQL 6.5 server.....when i create a temporary table,
i block other users in other databases. Actually i run a stored procedure which creates a temporary table and then the procedure insets some values of a table from my test database. When the spored procedure is executed, users in other databases also get blocked and no new user will be allowd to log on to the server. When i check as to what the other users are executing, i find that they are also creting or droping a temp table.
So i will have to either kill my SP or let it finish and continue blocking other users.
As of now, i am not able to find a reason for that and i try to run the Stored procedure in offpeak hrs.
I have not played around much with Temp tables in SQL 6.5. Pl do suggest me as to what to do....
Some details you would be interested on :
Server - SQL Server 6.5
Front End - Great Plains
Size of Tempdb - Data Space Available( It says shared with data)
database_name database_size unallocated space
------------------------------ ------------------ ------------------
tempdb 1502.00 MB -6301.82 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
7991108 KB 7996222 KB 72 KB -5186 KB
Hope this information helps.
Thanks in Advance...
Siv
I have a dumb ?
When I go in to expand the tempdb to at least 25mb req. for the migration
It is actually expanding the Log size & the Db available size still says 1.76mb.
What am I doing wrong?
Thanx for your time
Rick C
Hi, our tempdb log keeps filling up and suggests we back it up. Can we double the size of the log file if we are using simple recovery?
View 1 Replies View Related