Access Violation error for one table in db

Question

Access Violation error for one table in db

Phil Manheim

Valued Member

Points: 57
More actions
November 7, 2005 at 11:23 am

#102911

When I try to query one table in my db, I get an error that says, "SqlDumpExceptionHandler: Process X generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process." It also creates dumps and log files. Everything works fine with any other tables in the db. Please advise.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 1

Posting the query and the DDL might help. Otherwise you will get a lot of responses saying things like: "well that sucks... good luck fixing it".

A.J.
DBA with an attitude

Phil Manheim Valued Member Points: 57 More actions · Answer 2

I get the same error on any query, so "select *" is a fine example. What part of the dump.txt file would be helpful? I can't imagine anybody wants me to copy the whole thing in here.

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 3

Wow, that is strange. I would recommend contacting MS about this. I unfortuneately cannot offer any additional advice. Is there anything about this table that makes it different than other tables in the database?

A.J.
DBA with an attitude

Phil Manheim Valued Member Points: 57 More actions · Answer 4

There is nothing special about this table. This all started randomly on a Sunday when nobody was working on anything, so the only thing I can think of is that customer entered some data that corrupted that table. Is that possible? Or is it possible that it is an actual bug that SP4 would fix?

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 5

Have you ran DBCC CHECKDB on the database?

A.J.
DBA with an attitude

Phil Manheim Valued Member Points: 57 More actions · Answer 6

Phil Manheim

Valued Member

Points: 57

November 7, 2005 at 1:06 pm

#602669

No. How do I go about doing that?

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 7

Open Query analyzer -- connect to the database.

Run the command:

DBCC CHECKDB

Post the output...

A.J.
DBA with an attitude

Phil Manheim Valued Member Points: 57 More actions · Answer 8

I ran checkdb and it returned the following (the first line and 2nd to last line don't really seem to match up):

Database 'gadata' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECK processing.

DBCC results for 'gadata'.

DBCC results for 'sysobjects'.

There are 660 rows in 14 pages for object 'sysobjects'.

DBCC results for 'sysindexes'.

There are 1382 rows in 75 pages for object 'sysindexes'.

DBCC results for 'syscolumns'.

There are 2284 rows in 41 pages for object 'syscolumns'.

DBCC results for 'systypes'.

There are 26 rows in 1 pages for object 'systypes'.

DBCC results for 'syscomments'.

There are 365 rows in 24 pages for object 'syscomments'.

DBCC results for 'sysfiles1'.

There are 2 rows in 1 pages for object 'sysfiles1'.

DBCC results for 'syspermissions'.

There are 72 rows in 1 pages for object 'syspermissions'.

DBCC results for 'sysusers'.

There are 15 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 514 rows in 2 pages for object 'sysdepends'.

DBCC results for 'sysreferences'.

There are 59 rows in 1 pages for object 'sysreferences'.

DBCC results for 'sysfulltextcatalogs'.

There are 0 rows in 1 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 'programAttributesGroupLink'.

There are 30 rows in 1 pages for object 'programAttributesGroupLink'.

DBCC results for 'reward_cart_extra'.

There are 27927 rows in 116 pages for object 'reward_cart_extra'.

DBCC results for 'programAttributesGroupPartnerLink'.

There are 18 rows in 1 pages for object 'programAttributesGroupPartnerLink'.

DBCC results for 'programAttributesValues'.

There are 72 rows in 2 pages for object 'programAttributesValues'.

DBCC results for 'reward_cart_extra_type'.

There are 9 rows in 1 pages for object 'reward_cart_extra_type'.

DBCC results for 'reward_user_access_failures'.

There are 3126 rows in 25 pages for object 'reward_user_access_failures'.

DBCC results for 'moreinfo'.

There are 1399 rows in 46 pages for object 'moreinfo'.

DBCC results for 'reward_employees'.

There are 6948 rows in 132 pages for object 'reward_employees'.

DBCC results for 'salesUserSalesModifiersLink'.

There are 1691752 rows in 6389 pages for object 'salesUserSalesModifiersLink'.

DBCC results for 'gcmail'.

There are 263194 rows in 7284 pages for object 'gcmail'.

DBCC results for 'session_manager'.

There are 10892833 rows in 136452 pages for object 'session_manager'.

DBCC results for 'siteURL'.

There are 250 rows in 5 pages for object 'siteURL'.

DBCC results for 'reward_company_mgr_info'.

There are 68 rows in 4 pages for object 'reward_company_mgr_info'.

DBCC results for 'merctrans'.

There are 145116 rows in 1678 pages for object 'merctrans'.

DBCC results for 'admin'.

There are 10 rows in 2 pages for object 'admin'.

DBCC results for 'verizon_conversions'.

There are 760 rows in 8 pages for object 'verizon_conversions'.

DBCC results for 'reward_company_info'.

There are 183 rows in 2 pages for object 'reward_company_info'.

DBCC results for 'IntegerToString'.

There are 200 rows in 2 pages for object 'IntegerToString'.

DBCC results for 'BGcolor'.

There are 0 rows in 1 pages for object 'BGcolor'.

DBCC results for 'Enabling'.

There are 126 rows in 4 pages for object 'Enabling'.

DBCC results for 'Cats'.

There are 15 rows in 1 pages for object 'Cats'.

DBCC results for 'error_log'.

There are 63394 rows in 1055 pages for object 'error_log'.

DBCC results for 'salesUserExtra'.

There are 402 rows in 5 pages for object 'salesUserExtra'.

DBCC results for 'promo'.

There are 50 rows in 2 pages for object 'promo'.

DBCC results for 'merchant_website_search_names'.

There are 22239 rows in 111 pages for object 'merchant_website_search_names'.

DBCC results for 'CatLnk'.

There are 3628 rows in 19 pages for object 'CatLnk'.

DBCC results for 'tcom_delivery_methods'.

There are 6 rows in 2 pages for object 'tcom_delivery_methods'.

DBCC results for 'reward_orders'.

There are 150840 rows in 5174 pages for object 'reward_orders'.

DBCC results for 'motiv_show'.

There are 982 rows in 20 pages for object 'motiv_show'.

DBCC results for 'cookie'.

There are 15102 rows in 589 pages for object 'cookie'.

DBCC results for 'reward_merchant'.

There are 203 rows in 5 pages for object 'reward_merchant'.

DBCC results for 'country'.

There are 235 rows in 2 pages for object 'country'.

DBCC results for 'paramax_slot_gc_gen'.

There are 773 rows in 5 pages for object 'paramax_slot_gc_gen'.

DBCC results for 'session_order'.

There are 292541 rows in 24265 pages for object 'session_order'.

DBCC results for 'reward_cert_req_link'.

There are 574 rows in 7 pages for object 'reward_cert_req_link'.

DBCC results for 'customfm'.

There are 107 rows in 4 pages for object 'customfm'.

DBCC results for 'delivery'.

There are 5 rows in 1 pages for object 'delivery'.

DBCC results for 'storagetek_employees'.

There are 4881 rows in 79 pages for object 'storagetek_employees'.

DBCC results for 'reward_orders_batch'.

There are 669 rows in 17 pages for object 'reward_orders_batch'.

DBCC results for 'fimage'.

There are 95 rows in 2 pages for object 'fimage'.

DBCC results for 'reward_company_department_code'.

There are 1377 rows in 15 pages for object 'reward_company_department_code'.

DBCC results for 'Verizon4_sales'.

There are 2496 rows in 36 pages for object 'Verizon4_sales'.

DBCC results for 'fimagespnd'.

There are 2 rows in 1 pages for object 'fimagespnd'.

DBCC results for 'reward_atb'.

There are 163 rows in 7 pages for object 'reward_atb'.

DBCC results for 'admin_users'.

There are 4 rows in 1 pages for object 'admin_users'.

DBCC results for 'action'.

There are 1793519 rows in 25745 pages for object 'action'.

DBCC results for 'gcaddvalue'.

There are 24725 rows in 927 pages for object 'gcaddvalue'.

DBCC results for 'CR_CategoryFeaturedMerchants'.

There are 1407 rows in 15 pages for object 'CR_CategoryFeaturedMerchants'.

DBCC results for 'customerServiceCategory'.

There are 6 rows in 1 pages for object 'customerServiceCategory'.

DBCC results for 'salesUserSalesModifiers'.

There are 2789 rows in 36 pages for object 'salesUserSalesModifiers'.

DBCC results for 'customerServiceCategoryLink'.

There are 8 rows in 2 pages for object 'customerServiceCategoryLink'.

DBCC results for 'CR_PremiumMerchants'.

There are 331 rows in 13 pages for object 'CR_PremiumMerchants'.

DBCC results for 'reward_company_extra_type'.

There are 115 rows in 3 pages for object 'reward_company_extra_type'.

DBCC results for 'home_gc'.

There are 1070 rows in 9 pages for object 'home_gc'.

DBCC results for 'home_gcmail'.

There are 1257 rows in 56 pages for object 'home_gcmail'.

DBCC results for 'reward_catalogs'.

There are 2841 rows in 50 pages for object 'reward_catalogs'.

DBCC results for 'bandm_orders'.

There are 3409 rows in 172 pages for object 'bandm_orders'.

DBCC results for 'orderComment'.

There are 14371 rows in 126 pages for object 'orderComment'.

DBCC results for 'home_gcpurchase'.

There are 1070 rows in 8 pages for object 'home_gcpurchase'.

DBCC results for 'cash_orders'.

There are 4345 rows in 225 pages for object 'cash_orders'.

DBCC results for 'ecardSend'.

There are 27174 rows in 912 pages for object 'ecardSend'.

DBCC results for 'home_history'.

There are 1257 rows in 67 pages for object 'home_history'.

DBCC results for 'SalesProgram'.

There are 54 rows in 5 pages for object 'SalesProgram'.

DBCC results for 'maillist'.

There are 1429 rows in 10 pages for object 'maillist'.

DBCC results for 'gcdelivery'.

There are 632795 rows in 10609 pages for object 'gcdelivery'.

DBCC results for 'ExchangeRateLog'.

There are 57300 rows in 307 pages for object 'ExchangeRateLog'.

DBCC results for 'merkeyword'.

There are 3063 rows in 68 pages for object 'merkeyword'.

DBCC results for 'ecardCategory'.

There are 18 rows in 1 pages for object 'ecardCategory'.

DBCC results for 'ecardCategoryLink'.

There are 95 rows in 6 pages for object 'ecardCategoryLink'.

DBCC results for 'gaSite'.

There are 0 rows in 1 pages for object 'gaSite'.

DBCC results for 'reward_merchant_link'.

There are 3472 rows in 34 pages for object 'reward_merchant_link'.

DBCC results for 'reward_merchant_sku'.

There are 326 rows in 7 pages for object 'reward_merchant_sku'.

DBCC results for 'gaSite_user'.

There are 0 rows in 1 pages for object 'gaSite_user'.

DBCC results for 'Comcast_Customers'.

There are 8 rows in 1 pages for object 'Comcast_Customers'.

DBCC results for 'reward_atb_certificates'.

There are 1990244 rows in 10597 pages for object 'reward_atb_certificates'.

DBCC results for 'gaUserAddressbook'.

There are 1925 rows in 18 pages for object 'gaUserAddressbook'.

DBCC results for 'gaUser'.

There are 121959 rows in 2483 pages for object 'gaUser'.

DBCC results for 'supportGroup'.

There are 9 rows in 1 pages for object 'supportGroup'.

DBCC results for 'gaUserEvent'.

There are 151 rows in 2 pages for object 'gaUserEvent'.

DBCC results for 'reward_orders_file'.

There are 3420 rows in 43 pages for object 'reward_orders_file'.

DBCC results for 'supportClass'.

There are 10 rows in 1 pages for object 'supportClass'.

DBCC results for 'swingintosummer'.

There are 6678 rows in 118 pages for object 'swingintosummer'.

DBCC results for 'promocode'.

There are 130 rows in 3 pages for object 'promocode'.

DBCC results for 'ExchangeRateSource'.

There are 4 rows in 2 pages for object 'ExchangeRateSource'.

DBCC results for 'reward_orders_status'.

There are 866524 rows in 8884 pages for object 'reward_orders_status'.

DBCC results for 'supportGroupClass'.

There are 15 rows in 1 pages for object 'supportGroupClass'.

DBCC results for 'siteScheduledTask'.

There are 0 rows in 1 pages for object 'siteScheduledTask'.

DBCC results for 'salesUserActionLink'.

There are 445 rows in 3 pages for object 'salesUserActionLink'.

DBCC results for 'reward_user_cart_extra'.

There are 18993 rows in 82 pages for object 'reward_user_cart_extra'.

DBCC results for 'tax'.

There are 51 rows in 1 pages for object 'tax'.

DBCC results for 'top_25'.

There are 301 rows in 3 pages for object 'top_25'.

DBCC results for 'dtproperties'.

There are 35 rows in 1 pages for object 'dtproperties'.

DBCC results for 'reward_cert_requests'.

There are 694 rows in 31 pages for object 'reward_cert_requests'.

DBCC results for 'tracker'.

There are 617 rows in 9 pages for object 'tracker'.

DBCC results for 'SupportTrackerNotes'.

There are 0 rows in 0 pages for object 'SupportTrackerNotes'.

DBCC results for 'gillette_employees'.

There are 6564 rows in 76 pages for object 'gillette_employees'.

DBCC results for 'SupportTracker'.

There are 0 rows in 0 pages for object 'SupportTracker'.

DBCC results for 'reward_user_password_req_log'.

There are 1072 rows in 11 pages for object 'reward_user_password_req_log'.

DBCC results for 'reward_user_info_log'.

There are 448 rows in 11 pages for object 'reward_user_info_log'.

DBCC results for 'ecard'.

There are 159 rows in 3 pages for object 'ecard'.

DBCC results for 'salesUserSales'.

There are 538606 rows in 6695 pages for object 'salesUserSales'.

DBCC results for 'salesUserSalesExtraValue'.

There are 1311324 rows in 6226 pages for object 'salesUserSalesExtraValue'.

DBCC results for 'reward_user_key_log'.

There are 2067 rows in 26 pages for object 'reward_user_key_log'.

DBCC results for 'reward_user_extra'.

There are 57912 rows in 262 pages for object 'reward_user_extra'.

DBCC results for 'pointExchange'.

There are 11 rows in 1 pages for object 'pointExchange'.

DBCC results for 'reward_gc'.

There are 84183 rows in 579 pages for object 'reward_gc'.

DBCC results for 'reward_user_extra_type'.

There are 11 rows in 2 pages for object 'reward_user_extra_type'.

DBCC results for 'verizon_users'.

There are 508 rows in 18 pages for object 'verizon_users'.

DBCC results for 'reward_user_fund_schedule'.

There are 1292 rows in 13 pages for object 'reward_user_fund_schedule'.

DBCC results for 'gcpurchase'.

There are 632900 rows in 21677 pages for object 'gcpurchase'.

DBCC results for 'reward_company_merchant'.

There are 1211 rows in 7 pages for object 'reward_company_merchant'.

DBCC results for 'salesUserSalesModifierExtra'.

There are 8 rows in 1 pages for object 'salesUserSalesModifierExtra'.

DBCC results for 'reward_company_extra'.

There are 859 rows in 14 pages for object 'reward_company_extra'.

DBCC results for 'banner_categories'.

There are 210 rows in 3 pages for object 'banner_categories'.

DBCC results for 'security_application'.

There are 3 rows in 1 pages for object 'security_application'.

DBCC results for 'banner_location'.

There are 17944 rows in 267 pages for object 'banner_location'.

DBCC results for 'security_application_group'.

There are 12 rows in 2 pages for object 'security_application_group'.

DBCC results for 'salesUserSalesModifierExtraLink'.

There are 172 rows in 1 pages for object 'salesUserSalesModifierExtraLink'.

DBCC results for 'security_application_group_items'.

There are 75 rows in 5 pages for object 'security_application_group_items'.

DBCC results for 'iisrewards_employees'.

There are 4016 rows in 58 pages for object 'iisrewards_employees'.

DBCC results for 'programUserResponse'.

There are 229491 rows in 4659 pages for object 'programUserResponse'.

DBCC results for 'gaUserPrefix'.

There are 20 rows in 2 pages for object 'gaUserPrefix'.

DBCC results for 'security_application_group_users'.

There are 19 rows in 8 pages for object 'security_application_group_users'.

DBCC results for 'temp_trans'.

There are 757 rows in 11 pages for object 'temp_trans'.

DBCC results for 'security_application_items'.

There are 46 rows in 2 pages for object 'security_application_items'.

DBCC results for 'fuzzy_math_calcs'.

There are 2 rows in 1 pages for object 'fuzzy_math_calcs'.

DBCC results for 'cc_admin'.

There are 5 rows in 1 pages for object 'cc_admin'.

DBCC results for 'tcom_company'.

There are 60 rows in 3 pages for object 'tcom_company'.

DBCC results for 'cctype'.

There are 5 rows in 1 pages for object 'cctype'.

DBCC results for 'reward_user_cart'.

There are 22557 rows in 941 pages for object 'reward_user_cart'.

DBCC results for 'verizon_sales'.

There are 6525 rows in 97 pages for object 'verizon_sales'.

DBCC results for 'cr_moreinfo'.

There are 14 rows in 2 pages for object 'cr_moreinfo'.

DBCC results for 'mercMasterMercWantedLink'.

There are 12 rows in 2 pages for object 'mercMasterMercWantedLink'.

DBCC results for 'cr_tour'.

There are 6 rows in 1 pages for object 'cr_tour'.

DBCC results for 'forwarder'.

There are 60 rows in 2 pages for object 'forwarder'.

DBCC results for 'mercWanted'.

There are 3 rows in 1 pages for object 'mercWanted'.

DBCC results for 'email_marketing'.

There are 1 rows in 1 pages for object 'email_marketing'.

DBCC results for 'siteLink'.

There are 230 rows in 3 pages for object 'siteLink'.

DBCC results for 'mercWantedSearchTerms'.

There are 9 rows in 2 pages for object 'mercWantedSearchTerms'.

DBCC results for 'reward_group'.

There are 124 rows in 12 pages for object 'reward_group'.

DBCC results for 'gc_purgatory'.

There are 1854 rows in 24 pages for object 'gc_purgatory'.

DBCC results for 'gcground'.

There are 211187 rows in 5084 pages for object 'gcground'.

DBCC results for 'gctrans'.

There are 377610 rows in 3148 pages for object 'gctrans'.

DBCC results for 'gcprint'.

There are 167416 rows in 2330 pages for object 'gcprint'.

DBCC results for 'statusList'.

There are 13 rows in 1 pages for object 'statusList'.

DBCC results for 'admin_rights'.

There are 2 rows in 1 pages for object 'admin_rights'.

DBCC results for 'humanclick'.

There are 4 rows in 1 pages for object 'humanclick'.

DBCC results for 'reward_user'.

There are 16222 rows in 289 pages for object 'reward_user'.

DBCC results for 'siteEmail'.

There are 11 rows in 2 pages for object 'siteEmail'.

DBCC results for 'reward_user_access_log'.

There are 52498 rows in 265 pages for object 'reward_user_access_log'.

DBCC results for 'siterep_admin'.

There are 8 rows in 1 pages for object 'siterep_admin'.

DBCC results for 'salesUsers'.

There are 20682 rows in 339 pages for object 'salesUsers'.

DBCC results for 'siterep_category'.

There are 5 rows in 2 pages for object 'siterep_category'.

DBCC results for 'gc'.

There are 632255 rows in 11094 pages for object 'gc'.

DBCC results for 'reward_user_account'.

There are 7232 rows in 52 pages for object 'reward_user_account'.

DBCC results for 'siterep_items'.

There are 50 rows in 2 pages for object 'siterep_items'.

DBCC results for 'admin_user_access_log'.

There are 0 rows in 1 pages for object 'admin_user_access_log'.

DBCC results for 'salesProgramSiteGcPrefixLink'.

There are 57 rows in 6 pages for object 'salesProgramSiteGcPrefixLink'.

DBCC results for 'siterep_notes'.

There are 60 rows in 3 pages for object 'siterep_notes'.

DBCC results for 'tcom_user'.

There are 62 rows in 3 pages for object 'tcom_user'.

DBCC results for 'reward_user_info'.

There are 16516 rows in 213 pages for object 'reward_user_info'.

DBCC results for 'mercmaster'.

There are 3046 rows in 141 pages for object 'mercmaster'.

DBCC results for 'siterep_subcategory'.

There are 29 rows in 2 pages for object 'siterep_subcategory'.

DBCC results for 'salesProgramUserLink'.

There are 22753 rows in 153 pages for object 'salesProgramUserLink'.

DBCC results for 'special_offers'.

There are 276 rows in 17 pages for object 'special_offers'.

DBCC results for 'tcom_user_access_log'.

There are 1707 rows in 15 pages for object 'tcom_user_access_log'.

DBCC results for 'tcom_user_account'.

There are 266 rows in 5 pages for object 'tcom_user_account'.

DBCC results for 'salesProgramSiteURLLink'.

There are 78 rows in 8 pages for object 'salesProgramSiteURLLink'.

DBCC results for 'tcom_user_info'.

There are 62 rows in 3 pages for object 'tcom_user_info'.

DBCC results for 'verizon4_users'.

There are 682 rows in 14 pages for object 'verizon4_users'.

DBCC results for 'Affiliates'.

There are 11 rows in 1 pages for object 'Affiliates'.

DBCC results for 'reward_company'.

There are 124 rows in 4 pages for object 'reward_company'.

DBCC results for 'employee'.

There are 0 rows in 0 pages for object 'employee'.

DBCC results for 'merlisting'.

There are 3048 rows in 114 pages for object 'merlisting'.

DBCC results for 'verizon3_sales'.

There are 12585 rows in 221 pages for object 'verizon3_sales'.

DBCC results for 'tcom_gc'.

There are 2053 rows in 24 pages for object 'tcom_gc'.

DBCC results for 'paramax_gc_gen'.

There are 2902 rows in 16 pages for object 'paramax_gc_gen'.

DBCC results for 'site'.

There are 12 rows in 1 pages for object 'site'.

DBCC results for 'employeeExtra'.

There are 0 rows in 0 pages for object 'employeeExtra'.

DBCC results for 'reward_orders_atb_batch'.

There are 75648 rows in 870 pages for object 'reward_orders_atb_batch'.

DBCC results for 'siteAttributes'.

There are 51 rows in 1 pages for object 'siteAttributes'.

DBCC results for 'tcom_group'.

There are 60 rows in 3 pages for object 'tcom_group'.

DBCC results for 'siteAttributesGroup'.

There are 5 rows in 1 pages for object 'siteAttributesGroup'.

DBCC results for 'tcom_express_awards_user'.

There are 356 rows in 9 pages for object 'tcom_express_awards_user'.

DBCC results for 'signup'.

There are 8893 rows in 1106 pages for object 'signup'.

DBCC results for 'siteAttributesGroupLink'.

There are 62 rows in 1 pages for object 'siteAttributesGroupLink'.

DBCC results for 'siteAttributesGroupSiteLink'.

There are 13 rows in 1 pages for object 'siteAttributesGroupSiteLink'.

DBCC results for 'employeeExtraValue'.

There are 0 rows in 0 pages for object 'employeeExtraValue'.

DBCC results for 'gccombined'.

There are 32394 rows in 488 pages for object 'gccombined'.

DBCC results for 'siteAttributesValues'.

There are 131 rows in 2 pages for object 'siteAttributesValues'.

DBCC results for 'fraud_log'.

There are 1 rows in 1 pages for object 'fraud_log'.

DBCC results for 'Cart'.

There are 386908 rows in 19655 pages for object 'Cart'.

DBCC results for 'reward_product'.

There are 7 rows in 1 pages for object 'reward_product'.

DBCC results for 'siorderdata'.

There are 597693 rows in 13484 pages for object 'siorderdata'.

DBCC results for 'maritzFileResponse'.

There are 72497 rows in 273 pages for object 'maritzFileResponse'.

DBCC results for 'realTimeLog'.

There are 277188 rows in 3846 pages for object 'realTimeLog'.

DBCC results for 'recipientTempUpload'.

There are 133682 rows in 2006 pages for object 'recipientTempUpload'.

DBCC results for 'guardian_feedback'.

There are 19 rows in 1 pages for object 'guardian_feedback'.

DBCC results for 'customerService'.

There are 13 rows in 1 pages for object 'customerService'.

DBCC results for 'reward_product_extra'.

There are 21 rows in 1 pages for object 'reward_product_extra'.

DBCC results for 'siteGcPrefix'.

There are 274 rows in 6 pages for object 'siteGcPrefix'.

DBCC results for 'reward_product_message'.

There are 2 rows in 1 pages for object 'reward_product_message'.

DBCC results for 'acs_employees'.

There are 6 rows in 2 pages for object 'acs_employees'.

DBCC results for 'vwrm_employees'.

There are 5955 rows in 105 pages for object 'vwrm_employees'.

DBCC results for 'reward_product_catalogs'.

There are 0 rows in 0 pages for object 'reward_product_catalogs'.

DBCC results for 'aetna_employees'.

There are 1078 rows in 14 pages for object 'aetna_employees'.

DBCC results for 'banner'.

There are 67 rows in 3 pages for object 'banner'.

DBCC results for 'partner'.

There are 6 rows in 1 pages for object 'partner'.

DBCC results for 'program'.

There are 26 rows in 2 pages for object 'program'.

DBCC results for 'corporate_program'.

There are 151 rows in 24 pages for object 'corporate_program'.

DBCC results for 'programAttributes'.

There are 26 rows in 1 pages for object 'programAttributes'.

DBCC results for 'reward_product_orders'.

There are 11 rows in 1 pages for object 'reward_product_orders'.

DBCC results for 'actionName'.

There are 19 rows in 3 pages for object 'actionName'.

DBCC results for 'tcom_company_info'.

There are 67 rows in 3 pages for object 'tcom_company_info'.

DBCC results for 'programAttributesGroup'.

There are 3 rows in 1 pages for object 'programAttributesGroup'.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'gadata'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 9

well it doesn't look like you have any "corrupt" data. I am at a loss now.

A.J.
DBA with an attitude

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 10

not sure what the

Database 'gadata' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECK processing.

means....

A.J.
DBA with an attitude

Adam Wilbur SSCertifiable Points: 7001 More actions · Answer 11

well looks like you got some work ahead of you. Try running

DBCC CHECKTABLE with the REPAIR_REBUILD option for each table in the database.

These links should get you started

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2833

http://support.microsoft.com/kb/818097

A.J.
DBA with an attitude

Jeff Gray SSChampion Points: 10667 More actions · Answer 12

I would also check http://support.microsoft.com/kb/293177/

jg