Hi folks,
I have 3 tables of related data in SQL 2000/2005 that receive periodic adds/updates every 30 seconds.
I have enabled transactions on all updates, is anything else needed to ensure data consistency during reads in a high # of fetches per second situation?
Thanks,
john
Edit:
Clarification -- I just need the data to be correctly displayed to all users.
What is the mechanism used by select statements to return point in time data?
I have a test setup - table t1 has 1000000 rows. A query (call q1) that selects all the rows (in NOLOCK mode and process them) takes 10 minutes. At the same time another process inserts another 1000000 rows into the same table t1. As expected, client that issued query q1 sees just 1000000 rows.
My understanding is that NOLOCK does not hold any locks. So, how did SQL Server know that it should not return the rows that are inserted after I issued the query q1? Some explanation or link to some whitepapers would be helpful.
Thanks
I want to make data changes in read_only database , that's why i must set database read_write. While database is at read_write mode, i want to be sure that no one makes change in database.
For this aim, i write the code below, but i suspect that after setting the database read_write, till the setting database
single_user ,is it possible get DML script from another user. Is the code below enough for this operation. Or is there another way?
Reminding: Read_only database can not be set single_user mode. That's why, first you must set database read_write.
The code;
use master
alter database xxx set read_write
with rollback immediate
alter database xxx set single_user
with rollback immediate
use xxx
update tablexxx set columnxxx=yyy
use master
alter database xxx set read_only
with rollback immediate
alter database xxx set multi_user
with rollback immediate
Vimal Kanth writes "I am using SQL Server 2000 and one of my databases has loads of consistency errors. When i try to query a particular record from a table it displays an error message similar to this
Could not find the index entry for RID '168927001232500300' in index page (1:95510), index ID 0, database 'Tristar'.
Then, i executed the DBCC CHECKDB command after going through some documentation. The results of which were something like this
Table error: Database 'Tristar', index 'DMS_VOUCHER.index_1739153241' (ID 1739153241) (index ID 2). Extra or invalid key for the keys:
Index row (1:11229:144) with values (ROWGUID = 22814645-5B2B-4B4E-A1D8-9B49DF7C8CEF`¢0; and DEALER_ID = 10121 and BRANCH_ID = 1.242260474E-307 and VOUCHER_ID = 9507) points to the data row identified by ().
Then, i executed the DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command. I lost around 3000 records when i excuted this
I dont want any data loss as this is very critical.Can you please help me overcome this problem? Thanks in advance.
Regards
Vimal Kanth"
Can anyone please tell me why I recieved these errors when running dbcc check db. Thank god it was a user created "test" table in a production database and I was able to just drop the table and rerun dbcc with no errors, but this is the second time this has happened in the last month(I just started this job the week of the first error)- and we ended up having to restore to the last good backup.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 3, text ID 225434796032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 4, text ID 225434861568 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1543676547, index ID 255: Page (1:652193) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1543676547, index ID 255, page (1:652193). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 0, text ID 225434730496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 1, text ID 225434927104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 2, text ID 225434992640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 3, text ID 225435058176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 4, text ID 225435123712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 5, text ID 225435189248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 6, text ID 225435254784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 7, text ID 225435320320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 0, text ID 225435385856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 1, text ID 225435451392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 2, text ID 225435516928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 3, text ID 225435582464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 4, text ID 225435648000 is not referenced.
DBCC results for 'BILL_PRT_DETAIL'.
There are 909154 rows in 101409 pages for object 'BILL_PRT_DETAIL'.
DBCC results for 'BILLG_ERR_MSGS'.
There are 971 rows in 52 pages for object 'BILLG_ERR_MSGS'.
DBCC results for 'WORK_COMPCY_LEVEL'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_LEVEL'.
DBCC results for 'BILL_PRT_HEADER'.
There are 196396 rows in 24550 pages for object 'BILL_PRT_HEADER'.
DBCC results for 'WORK_COMPCY_TYPE'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_TYPE'.
DBCC results for 'BILL_PRT_MSGS'.
There are 0 rows in 0 pages for object 'BILL_PRT_MSGS'.
DBCC results for 'MTR_TMP_DTA_SEL'.
There are 0 rows in 0 pages for object 'MTR_TMP_DTA_SEL'.
DBCC results for 'WORK_IN_PROGRESS'.
There are 1 rows in 1 pages for object 'WORK_IN_PROGRESS'.
DBCC results for 'BILL_PYMT'.
There are 750053 rows in 19951 pages for object 'BILL_PYMT'.
DBCC results for 'NOTES'.
There are 26812 rows in 457 pages for object 'NOTES'.
DBCC results for 'WORK_ORDER_MASTER'.
There are 0 rows in 0 pages for object 'WORK_ORDER_MASTER'.
DBCC results for 'BUD_BILLG_AMT'.
There are 0 rows in 0 pages for object 'BUD_BILLG_AMT'.
DBCC results for 'NOTES_RELSHP'.
There are 22428 rows in 252 pages for object 'NOTES_RELSHP'.
DBCC results for 'WO_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_ACT_STAT'.
DBCC results for 'BUD_BILLG_CNSM_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_CNSM_HST'.
DBCC results for 'NXT_NBR'.
There are 7 rows in 1 pages for object 'NXT_NBR'.
DBCC results for 'WO_ADDTNL_INFO'.
There are 0 rows in 0 pages for object 'WO_ADDTNL_INFO'.
DBCC results for 'BUD_BILLG_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_HST'.
DBCC results for 'PARENT_HST'.
There are 0 rows in 0 pages for object 'PARENT_HST'.
DBCC results for 'WO_APPVL_ROUTING'.
There are 0 rows in 0 pages for object 'WO_APPVL_ROUTING'.
DBCC results for 'BUD_BILLG_WTHR_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_HST'.
DBCC results for 'PHY_ADDR'.
There are 70776 rows in 7905 pages for object 'PHY_ADDR'.
DBCC results for 'WO_BEHAVIOR_RULE'.
There are 0 rows in 0 pages for object 'WO_BEHAVIOR_RULE'.
DBCC results for 'BUD_BILLG_WTHR_SEV'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_SEV'.
DBCC results for 'POSTAL_TOWN_CD'.
There are 29539 rows in 569 pages for object 'POSTAL_TOWN_CD'.
DBCC results for 'WO_COMPONENTS'.
There are 0 rows in 0 pages for object 'WO_COMPONENTS'.
DBCC results for 'BUS_UNT'.
There are 1310 rows in 25 pages for object 'BUS_UNT'.
DBCC results for 'cash match'.
There are 738871 rows in 6720 pages for object 'cash match'.
DBCC results for 'POSTED_HISTORY'.
There are 1230436 rows in 26768 pages for object 'POSTED_HISTORY'.
DBCC results for 'WO_CONSTANTS'.
There are 0 rows in 0 pages for object 'WO_CONSTANTS'.
DBCC results for 'BUS_UNT_MSTR'.
There are 0 rows in 0 pages for object 'BUS_UNT_MSTR'.
DBCC results for 'Cashmatch7_30'.
There are 727509 rows in 6619 pages for object 'Cashmatch7_30'.
DBCC results for 'PROFILE_CAT'.
There are 0 rows in 0 pages for object 'PROFILE_CAT'.
DBCC results for 'WO_EDIT_RULE'.
There are 0 rows in 0 pages for object 'WO_EDIT_RULE'.
DBCC results for 'CNSMPTN_SVC_CONTN'.
There are 36776 rows in 928 pages for object 'CNSMPTN_SVC_CONTN'.
DBCC results for 'Trace_cash_match'.
There are 815011 rows in 7412 pages for object 'Trace_cash_match'.
DBCC results for 'PROOF_BILL_PRT_DTL'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_DTL'.
DBCC results for 'WO_MASTER_FILE'.
There are 0 rows in 0 pages for object 'WO_MASTER_FILE'.
DBCC results for 'cash match 8-24'.
There are 815011 rows in 7414 pages for object 'cash match 8-24'.
CHECKDB found 0 allocation errors and 17 consistency errors in table 'cash match 8-24' (object ID 1543676547).
DBCC results for 'PROOF_BILL_PRT_HDR'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_HDR'.
DBCC results for 'CNVRGT_BILLG_DTL'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_DTL'.
DBCC results for 'WO_RTG_APPVL_MSTR'.
There are 0 rows in 0 pages for object 'WO_RTG_APPVL_MSTR'.
DBCC results for 'PYMT_TERMS'.
There are 2 rows in 1 pages for object 'PYMT_TERMS'.
DBCC results for 'CNVRGT_BILLG_HDR'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_HDR'.
DBCC results for 'WO_STAT'.
There are 0 rows in 0 pages for object 'WO_STAT'.
DBCC results for 'Cash Matching Process'.
There are 836838 rows in 7612 pages for object 'Cash Matching Process'.
DBCC results for 'RD_CYCLE'.
There are 55 rows in 1 pages for object 'RD_CYCLE'.
DBCC results for 'WO_STAT_RULES'.
There are 0 rows in 0 pages for object 'WO_STAT_RULES'.
DBCC results for 'REASON_CD'.
There are 0 rows in 0 pages for object 'REASON_CD'.
DBCC results for 'WO_TYP'.
There are 0 rows in 0 pages for object 'WO_TYP'.
DBCC results for 'COLCT_RULES'.
There are 30 rows in 1 pages for object 'COLCT_RULES'.
DBCC results for 'RECEIPTS_BTCH'.
There are 2109 rows in 44 pages for object 'RECEIPTS_BTCH'.
DBCC results for 'nightly107'.
There are 344086 rows in 3225 pages for object 'nightly107'.
DBCC results for 'WO_TYP_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_TYP_ACT_STAT'.
DBCC results for 'COMPONENT_MASTER'.
There are 0 rows in 0 pages for object 'COMPONENT_MASTER'.
DBCC results for 'RECEIPTS_I_FILE'.
There are 51698 rows in 3244 pages for object 'RECEIPTS_I_FILE'.
DBCC results for 'NightCash10-12'.
There are 64657 rows in 592 pages for object 'NightCash10-12'.
DBCC results for 'WRK_CENTER_WRK_SCH'.
There are 0 rows in 0 pages for object 'WRK_CENTER_WRK_SCH'.
DBCC results for 'CONS_SVC_CONN_CD'.
There are 1524 rows in 20 pages for object 'CONS_SVC_CONN_CD'.
DBCC results for 'RECEIPT_ITM'.
There are 151581 rows in 6334 pages for object 'RECEIPT_ITM'.
DBCC results for 'Utiligy Cash Match Trace'.
There are 321627 rows in 2928 pages for object 'Utiligy Cash Match Trace'.
DBCC results for 'WRTOFF_GL_CLASS_CD'.
There are 0 rows in 0 pages for object 'WRTOFF_GL_CLASS_CD'.
DBCC results for 'CONTACT_INFO'.
There are 1 rows in 1 pages for object 'CONTACT_INFO'.
DBCC results for 'REFUND_HISTORY'.
There are 906 rows in 24 pages for object 'REFUND_HISTORY'.
DBCC results for 'RECEIPTS_I_FILE2'.
There are 48343 rows in 3022 pages for object 'RECEIPTS_I_FILE2'.
DBCC results for 'CUST_ADDR_REL'.
There are 70611 rows in 2258 pages for object 'CUST_ADDR_REL'.
DBCC results for 'REPORT_TYPE'.
There are 42 rows in 1 pages for object 'REPORT_TYPE'.
DBCC results for 'CUST_CNTRCT_RELSHP'.
There are 0 rows in 0 pages for object 'CUST_CNTRCT_RELSHP'.
DBCC results for 'REQ_READ_SCH'.
There are 1 rows in 1 pages for object 'REQ_READ_SCH'.
DBCC results for 'RESOURCE_ASGNDS'.
There are 0 rows in 0 pages for object 'RESOURCE_ASGNDS'.
DBCC results for 'CUST_INFO'.
There are 36779 rows in 2480 pages for object 'CUST_INFO'.
DBCC results for 'RESOURCE_MASTER'.
There are 0 rows in 0 pages for object 'RESOURCE_MASTER'.
DBCC results for 'RESOURCE_WORK_SCH'.
There are 0 rows in 0 pages for object 'RESOURCE_WORK_SCH'.
DBCC results for 'CUST_PYMT_ACCT'.
There are 0 rows in 0 pages for object 'CUST_PYMT_ACCT'.
DBCC results for 'ROUTE'.
There are 95 rows in 2 pages for object 'ROUTE'.
DBCC results for 'ADDR'.
There are 70767 rows in 861 pages for object 'ADDR'.
DBCC results for 'CUST_STMT_HST'.
There are 0 rows in 0 pages for object 'CUST_STMT_HST'.
DBCC results for 'ROUTE_RD_CYCLE'.
There are 0 rows in 0 pages for object 'ROUTE_RD_CYCLE'.
DBCC results for 'AGING_DAYS_TBL'.
There are 5 rows in 1 pages for object 'AGING_DAYS_TBL'.
DBCC results for 'CUST_SVC_RELSHP'.
There are 73551 rows in 1415 pages for object 'CUST_SVC_RELSHP'.
DBCC results for 'RPT_TYPE_CRITERIA'.
There are 116 rows in 2 pages for object 'RPT_TYPE_CRITERIA'.
DBCC results for 'AMX_MSG_LG'.
There are 0 rows in 0 pages for object 'AMX_MSG_LG'.
DBCC results for 'RPT_VERSION'.
There are 32 rows in 1 pages for object 'RPT_VERSION'.
DBCC results for 'DED_MTR_CONSUM'.
There are 0 rows in 0 pages for object 'DED_MTR_CONSUM'.
DBCC results for 'ASGND_BILL_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_BILL_CAT_CD'.
DBCC results for 'RPT_VRSN_CRITERIA'.
There are 15 rows in 1 pages for object 'RPT_VRSN_CRITERIA'.
DBCC results for 'DED_MTR_POS'.
There are 0 rows in 0 pages for object 'DED_MTR_POS'.
DBCC results for 'ASGND_CUST_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_CUST_CAT_CD'.
DBCC results for 'SCH_POOL'.
There are 0 rows in 0 pages for object 'SCH_POOL'.
DBCC results for 'DED_MTR_RDING_HIST'.
There are 0 rows in 0 pages for object 'DED_MTR_RDING_HIST'.
CHECKDB found 0 allocation errors and 17 consistency errors in database 'UtiligyPD'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (UtiligyPD ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Thanks!
Anita
Hello Experts,
Posted initial issue under following ID.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=77603
Here is output produced by DBCC CHECKDB
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:8) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:9) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:10) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:11) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:12) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:13) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:14) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:15) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:16) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:38) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:39) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:40) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:41) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:42) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:43) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:44) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:0) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:1) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:2) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:7) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:8) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:9) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:10) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:11) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:12) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:0) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:1) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:2) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:3) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:4) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:5) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:0) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:1) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:0) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:1) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:2) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:3) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:4) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:5) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:6) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:7) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:0) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:1) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:2) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:3) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:4) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:5) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:6) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:7) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:8) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-I' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:3) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:4) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:5) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:6) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-D' and ? = NULL) points to the data row identified by ().
DBCC results for 'dbS_CoreData'.
DBCC results for 'sysobjects'.
There are 341 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 610 rows in 42 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 2035 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 348 rows in 94 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 16 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 5 rows in 2 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2690 rows in 15 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 22 rows in 1 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 'tmp_KCE_Eval_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Eval_Round'.
DBCC results for 'tmp_KCE_Eval_Property'.
There are 20 rows in 1 pages for object 'tmp_KCE_Eval_Property'.
DBCC results for 'tmp_KCE_Eval_Task'.
There are 33 rows in 2 pages for object 'tmp_KCE_Eval_Task'.
DBCC results for 'tmp_KCE_Eval_Note'.
There are 113 rows in 3 pages for object 'tmp_KCE_Eval_Note'.
DBCC results for 'tmp_KCE_Train_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Train_Round'.
DBCC results for 'tmp_KCE_Train_Property'.
There are 30 rows in 1 pages for object 'tmp_KCE_Train_Property'.
DBCC results for 'tmp_KCE_Train_Task'.
There are 38 rows in 2 pages for object 'tmp_KCE_Train_Task'.
DBCC results for 'dlg_TeamCodes'.
There are 34 rows in 1 pages for object 'dlg_TeamCodes'.
DBCC results for 'cur_Round'.
There are 894 rows in 39 pages for object 'cur_Round'.
DBCC results for 'tmp_KCE_Train_Note'.
There are 160 rows in 4 pages for object 'tmp_KCE_Train_Note'.
DBCC results for 'dlg_Users'.
There are 397 rows in 16 pages for object 'dlg_Users'.
DBCC results for 'cur_Property'.
There are 92033 rows in 6880 pages for object 'cur_Property'.
DBCC results for 'cur_Task'.
There are 125253 rows in 9057 pages for object 'cur_Task'.
DBCC results for 'cur_Note'.
There are 339746 rows in 14089 pages for object 'cur_Note'.
CHECKDB found 0 allocation errors and 54 consistency errors in table 'cur_Note' (object ID 246291937).
DBCC results for 'arc_Note'.
There are 15609480 rows in 310776 pages for object 'arc_Note'.
DBCC results for 'arc_FieldNote'.
There are 1633726 rows in 41597 pages for object 'arc_FieldNote'.
DBCC results for 'dlg_UserTasks'.
There are 3116 rows in 39 pages for object 'dlg_UserTasks'.
DBCC results for 'dlg_ImportDetails'.
There are 1958 rows in 36 pages for object 'dlg_ImportDetails'.
DBCC results for 'arc_Property'.
There are 3729453 rows in 128092 pages for object 'arc_Property'.
DBCC results for 'arc_Round'.
There are 99219 rows in 2010 pages for object 'arc_Round'.
DBCC results for 'arc_Task'.
There are 5445171 rows in 185259 pages for object 'arc_Task'.
DBCC results for 'cur_FieldNote'.
There are 5647 rows in 242 pages for object 'cur_FieldNote'.
DBCC results for 'dlg_tmpAddZone'.
There are 0 rows in 15 pages for object 'dlg_tmpAddZone'.
DBCC results for 'dlg_Clients'.
There are 30 rows in 1 pages for object 'dlg_Clients'.
DBCC results for 'GenesisCheckReads'.
There are 13932 rows in 277 pages for object 'GenesisCheckReads'.
DBCC results for 'tmp_Duplicate_Tasks'.
There are 3947 rows in 127 pages for object 'tmp_Duplicate_Tasks'.
DBCC results for 'log_RoundActivity'.
There are 429434 rows in 5074 pages for object 'log_RoundActivity'.
DBCC results for 'copy_cur_Task'.
There are 138705 rows in 4439 pages for object 'copy_cur_Task'.
DBCC results for 'RoundTable'.
There are 5419 rows in 43 pages for object 'RoundTable'.
DBCC results for 'dlg_TaskTypes'.
There are 15 rows in 1 pages for object 'dlg_TaskTypes'.
DBCC results for 'log_Activity'.
There are 458463 rows in 9322 pages for object 'log_Activity'.
DBCC results for 'lib_RoundPerformance'.
There are 99387 rows in 2601 pages for object 'lib_RoundPerformance'.
DBCC results for 'dlg_SysUtilsRoundsRef'.
There are 1 rows in 1 pages for object 'dlg_SysUtilsRoundsRef'.
DBCC results for 'khutemp'.
There are 19747 rows in 470 pages for object 'khutemp'.
DBCC results for 'tmp_TempICPs'.
There are 14 rows in 1 pages for object 'tmp_TempICPs'.
DBCC results for 'dlg_Holidays'.
There are 53 rows in 1 pages for object 'dlg_Holidays'.
DBCC results for 'log_Comms'.
There are 2168949 rows in 73621 pages for object 'log_Comms'.
DBCC results for 'dlg_RefRound'.
There are 196 rows in 1 pages for object 'dlg_RefRound'.
DBCC results for 'Temp_RFICP'.
There are 38 rows in 1 pages for object 'Temp_RFICP'.
DBCC results for 'dlg_AreaCodes'.
There are 62 rows in 1 pages for object 'dlg_AreaCodes'.
DBCC results for 'dlg_GroupDetails'.
There are 350 rows in 5 pages for object 'dlg_GroupDetails'.
DBCC results for 'dlg_Countries'.
There are 3 rows in 1 pages for object 'dlg_Countries'.
DBCC results for 'dlg_Groups'.
There are 18 rows in 1 pages for object 'dlg_Groups'.
DBCC results for 'dlg_DumpResultImport'.
There are 0 rows in 0 pages for object 'dlg_DumpResultImport'.
DBCC results for 'dlg_Companies'.
There are 4 rows in 1 pages for object 'dlg_Companies'.
DBCC results for 'dlg_UserDetails'.
There are 188 rows in 3 pages for object 'dlg_UserDetails'.
DBCC results for 'tmp_EOLUnreadICPs'.
There are 28 rows in 1 pages for object 'tmp_EOLUnreadICPs'.
DBCC results for 'log_Importfiles'.
There are 2022 rows in 145 pages for object 'log_Importfiles'.
DBCC results for 'dlg_UserSecurity'.
There are 188 rows in 2 pages for object 'dlg_UserSecurity'.
DBCC results for 'log_LoginSession'.
There are 2049029 rows in 35632 pages for object 'log_LoginSession'.
DBCC results for 'dlg_DeviceDetails'.
There are 197 rows in 7 pages for object 'dlg_DeviceDetails'.
DBCC results for 'cur_FieldResult'.
There are 23907 rows in 899 pages for object 'cur_FieldResult'.
DBCC results for 'arc_FieldResult'.
There are 5539213 rows in 168533 pages for object 'arc_FieldResult'.
DBCC results for 'dlg_DialogServerLog'.
There are 1442 rows in 33 pages for object 'dlg_DialogServerLog'.
DBCC results for 'dlg_UserZones'.
There are 6484 rows in 56 pages for object 'dlg_UserZones'.
DBCC results for 'log_RPT_Selection_Crieteria'.
There are 64529 rows in 21127 pages for object 'log_RPT_Selection_Crieteria'.
DBCC results for 'log_Communication_Detail'.
There are 8175148 rows in 87720 pages for object 'log_Communication_Detail'.
DBCC results for 'dlg_ZoneCodes'.
There are 2268 rows in 28 pages for object 'dlg_ZoneCodes'.
DBCC results for 'DRQA01MRP'.
There are 83 rows in 2 pages for object 'DRQA01MRP'.
DBCC results for 'tmp_abc'.
There are 3 rows in 1 pages for object 'tmp_abc'.
DBCC results for 'dlg_DumpNoteImport'.
There are 14 rows in 1 pages for object 'dlg_DumpNoteImport'.
DBCC results for 'dlg_FilePaths'.
There are 1 rows in 1 pages for object 'dlg_FilePaths'.
DBCC results for 'dlg_MRPErrors'.
There are 296 rows in 12 pages for object 'dlg_MRPErrors'.
DBCC results for 'rpt_SubHeaderInfo'.
There are 46 rows in 3 pages for object 'rpt_SubHeaderInfo'.
DBCC results for 'dlg_SystemUtilities'.
There are 7 rows in 1 pages for object 'dlg_SystemUtilities'.
DBCC results for 'dlg_ErrorLog'.
There are 1401 rows in 49 pages for object 'dlg_ErrorLog'.
DBCC results for 'dlg_ExportDetails'.
There are 69883 rows in 4581 pages for object 'dlg_ExportDetails'.
DBCC results for 'dtproperties'.
There are 28 rows in 1 pages for object 'dtproperties'.
DBCC results for 'dlg_Tasks'.
There are 72 rows in 1 pages for object 'dlg_Tasks'.
DBCC results for 'log_RoundPerform'.
There are 0 rows in 0 pages for object 'log_RoundPerform'.
DBCC results for 'rpt_HeaderInfo'.
There are 4 rows in 1 pages for object 'rpt_HeaderInfo'.
DBCC results for 'dlg_Supervisors'.
There are 1613 rows in 13 pages for object 'dlg_Supervisors'.
CHECKDB found 0 allocation errors and 54 consistency errors in database 'dbS_CoreData'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (dbS_CoreData ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
*PLease LET ME KNOW WHAT IS RECOMMENED FURTHER STEP IN ORDER TO ELIMINATE THIS ERROR PERMANENTLY.. THANKS IN ADVANCE.
I am using SQL 2000 WITH sp4.
SKR
Hi
I have a table that stores the period and year as two seperate fields the problem that i have is that when the data is entered in the data base the period is sometime entered as 6 or 06, hence i have a table thaat looks like as follows:
Period Year
====== ====
6 2006
06 2005
12 2006
3 2005
2 2005
4 2005
04 2005
03 2005
when i currently query the information using the period i use the LIKE command in SQL which gives me the results but the problem is when the like is done with 2 as the period value it also retrieves the 12, 02, and 2, in that case the period 12 was not that was requested.
I was wondering is there a way to reformat the data so that all the data is in a consistent format?
Or is there a better way of quering the information in the current format?
Hi,
I'm working with the sample database called Adventure Works and I'm encountering data consistency issues :
If I sum the TotalDue for one particular territory, for one particular time window from the Sales. SalesOrderHeader table and if I try to compare the result to the LastYearSales and YTDSales from the Sales.SalesTerritory table, I don't get the same number, whatever I try. So did I miss something ?
How are the LastYearSales and YTDSales fields from Sales.SalesTerritory calculated ?
Thx,
Anissa
I have two production servers in the same data center. I need to ensure that database remains available if a catastrophic server failure or a disk failure occurs. I need to maintain transactional consistency of the data across both servers. I need to achieve these goals without manual intervention. I was suggested to use this optionTwo servers configured on the same subnet. SQL Server Availability Group configured in Synchronous-Commit Availability Mode<<<<But I think the correct answer should be Two servers configured in Windows Failover Cluster in the same data center SQL Server configured as a clustered instance<<<<
View 2 Replies View RelatedI have to build application Excel (interface) - SQL Server (backend)
I've created Data Source File "test.dsn" and tested succesfully.
SQL Server database in on the other machine.
This is a code that I am using.
And error message I am geting is "Cannot update. Database or object are read-only".
Dim cn As ADODB.Connection
Dim strSQL As String
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:Documents and SettingspdDesktopDevelopment est.xls;" & _
"Extended Properties=Excel 8.0"
strSQL = "INSERT INTO [DSN = test.dsn].Region Values(5, 'ab');"
cn.Execute strSQL
cn.Close
Set cn = Nothing
Read-only of databse properties is not selected.
Hello,
I am trying to read in from a csv file which works like this:
DECLARE @doesExist INT
DECLARE @fileName VARCHAR(200)
SET @fileName = 'c:file.csv'
SET NOCOUNT ON
EXEC xp_fileexist "' + @fileName + '", @doesExist OUTPUT
SET NOCOUNT OFF
IF @doesExist = 1
BEGIN
BULK INSERT OrdersBulk
FROM "' + @fileName + '"
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)
END
ELSE
print('Error cant find file')
What I want to do is check another table before each line inserts, if the data already exists I want to do an UPDATE.
I think i can do what i need with a cursor but I think the bulk update just pushes all the data up and will not allow me to put in the cursor.
So is there a way i can read the csv in a cursor instead of using the bulk insert so i can examine each row?
I have a stored procedure that updates a table. I also have an UDF that allows dirty reads (nolock).
What's the precedence level in SQL server? If I add xlock,rowlock to the update statement, will the dirty read wait for the update transaction to commit, or will it perform a dirty read regardless of the locking scheme in the update statement?
I am inserting updating few tables from snapshot and reading same bunch of tables from reporting using readcommitted . It is showing some deadlocks i think it is write in this situation as " x" is not compitable with "s" ,"is".
View 4 Replies View RelatedHi all, i got this error:
[DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
and also this:
[Excel Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "Fiscal Week" needs to be updated in the external metadata column collection. The column "Fiscal Year" needs to be updated in the external metadata column collection. The column "1st level" needs to be added to the external metadata column collection. The column "2nd level" needs to be added to the external metadata column collection. The column "3rd level" needs to be added to the external metadata column collection. The "external metadata column "1st Level" (16745)" needs to be removed from the external metadata column collection. The "external metadata column "3rd Level" (16609)" needs to be removed from the external metadata column collection. The "external metadata column "2nd Level" (16272)" needs to be removed from the external metadata column collection.
I tried going data flow->excel connection->advanced editor for excel source-> input and output properties and tried to refresh the columns affected.
It seems that somehow the 3 columns are not read in from the source file?
ans alslo fiscal year, fiscal week is not set up up properly in my data destination?
anyone faced such errors before?
Thanks
RE: XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data.
I want my XML Data source to be an expression as i will be looping through a directory of xml files.
I don't see the expression property or the connection property??
I tried setting the XMLData property to @[User::filename], but that results in:
Information: 0x40043006 at Load XML Files, DTS.Pipeline: Prepare for Execute phase is beginning.
Error: 0xC02090D0 at Load XML Files, XML Source [108]: The component "XML Source" (108) was unable to read the XML data.
Error: 0xC0047019 at Load XML Files, DTS.Pipeline: component "XML Source" (108) failed the prepare phase and returned error code 0xC02090D0.
Information: 0x4004300B at Load XML Files, DTS.Pipeline: "component "OLE DB Destination" (341)" wrote 0 rows.
Task failed: Load XML Files
Information: 0xC002F30E at Bad, File System Task: File or directory "d:jcpxmlLoadjcp2.xml.bad" was deleted.
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
The program '[3312] Package.dtsx: DTS' has exited with code 0 (0x0).
Thanks for any help or information.
Hi all,
I have a column in SQL server which is of type ntext. Selecting the specific column to view it in report builder, an error message appears with the following description:
- Cannot run this report. The grouping expression 'nameofcolumn' returns the datatype binary. The Grouping Expression cannot return binary data.
Report Builder recognises this as if it was an image...
Thanks in advance!
get the data from report to create data driven SSRS Subscriptions,
write query :
Running Report:
How can I read data from XML-file with exported data from MS Access? Which a dataflow component do I have to use?
Thanks in advance.
hi all
how i can read all the querys that send to the server
exmple
insert , update statement need all this statement at the end of the day how can i do that by sqlserver
thanks alot
Code Snippet
Dim ds As New DataSet
Dim adp As New SqlDataAdapter("Select MaxID,ValueName from tblSettings where ID=1", cn)
adp.Fill(ds)
If IsDBNull(ds.Tables(0).Columns("MaxID")) Then
GetMaxID = 1
Else
GetMaxID = ds.Tables(0).Columns("MaxID")
End If
the ds.Tables(0).Columns("MaxID") showing a value like this. ( Please tell how to read from sql data set)
{System.Data.DataColumn}
AllowDBNull: True
AutoIncrement: False
AutoIncrementSeed: 0
AutoIncrementStep: 1
Caption: "MAxid"
ColumnMapping: Element {1}
ColumnName: "MAxid"
Container: Nothing
DataType: {Name = "Decimal" FullName = "System.Decimal"}
DateTimeMode: UnspecifiedLocal {3}
DefaultValue: {System.DBNull}
DesignMode: False
Expression: ""
ExtendedProperties: Count = 0
MaxLength: -1
Namespace: ""
Ordinal: 0
Prefix: ""
ReadOnly: False
Site: Nothing
Table: {System.Data.DataTable}
Unique: False
I am having issues in figuring out how to read part of an XML file and I'm not sure if it can be done. Any and all help would be appreciated.
I have a file resembled this way:
<btb-root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" btb-num-trans="2"
btb-date="2006-11-09" btb-time="22:40:03" btb-sender="TTT"
btb-receipient="Test">
<btb-request req-method="Asynchronous">
<req-header>
<req-btb-id>Test</req-btb-id>
<req-client-id>Test</req-client-id>
<req-product>Test</req-product>
<req-loan-number>Test</req-loan-number>
</req-header>
<req-property-address>
<addr1>Test DR</addr1>
<city>Test</city>
<state>Test</state>
<zip>Test</zip>
</req-property-address>
<req-borrowers borr-type= "Borrower">
<first-name>Test</first-name>
<last-name>test</last-name>
</req-borrowers>
</btb-request>
</btb-root>
I am in need of extracting the date "2006-11-09" to a field in an import table contained in a sql database. I can pull all the other fields I need but in SSIS retrieving the date is not an option that I currently see. Does anyone know a way around this?
Thanks
I am using SQL 6.5 and we are going to upgrade to SQL 7. Has anyone
had any experience converting "read only" data? If so, I am looking
for tips and tricks. thanks in advance.
Hi,
Ik like to read data from a file (well formatted) into as MS-SQL database.
What is the best way to do this.
Jim
Hi,
I'm connecting to my SQL Server via Java in my Notes environment, but when I try to update my Notes-documents I get an error fra SQL Server saying that it can not re-read data from column 2.
Without being absolutely certain - I'm quite sure that the code is valid.
Does anyone know what the error means ?
Thanks in advance
Kim Hansen
hi all
right now , i am still learning how to use sql2005
is it possible if i want to read the backup data without restoring the backup database.? if it possible can you show me how to do it
cheers Arif
arifliminto86
1. In this topichttp://groups.google.com/group/comp...b21516252b65e7c,someone wrote: "I've implemented SET TRANSACTION ISOLATION LEVEL READUNCOMMITTED at the beginningof a number of stored procedures and, then SET TRANSACTION ISOLATIONLEVEL READCOMMITTED at the end to minimize the disruption to the application.".My question is, do you really need to set READ COMMITTED at the end ofstored procedure? What scope does that command affect?2. Could someone write some real world example where i should neverread uncommitted data... i'm having trouble understanding when ishould and when i should not use it.
View 7 Replies View RelatedHi,
I'm new to replication. Can anyone help with the following?
I want to publish the specific rows of data that are created on the publisher without accepting changes to those rows from subscribers, but do accept new rows (and changes to those rows) from subscribers.
EG. publisher creates rows 1 and 2 which are published to the subscriber
subscriber creates rows 3 and 4 which are merged back to the publisher
subscriber's updates (or delets) to rows 1 and 2 are not merged back to the publisher
So basically I want the publisher created rows to be published but remain as is whilst allowing subscriber created rows to be merged back to the publisher.
Hope is makes sense.
Thanks in advance,
Seedsy
Hi all,
I have noticed quite a few other posts about this error. My feeliing is that it has various causes requiring different remedies. I could not find anything suitable for my situation, so I post this in case someone can offer some tip.
The error happens during subscription report generation.
The following is from the SRS's log file:
ReportingServicesService!runningjobs!14!1/21/2008-10:35:37:: w WARN: Thread pool pressure. Using current thread for a work item.
ReportingServicesService!runningjobs!c!1/21/2008-10:36:28:: i INFO: Adding: 2 running jobs to the database
ReportingServicesService!library!c!1/21/2008-10:41:28:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!c!1/21/2008-10:48:28:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!processing!c!1/21/2008-10:48:28:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
ReportingServicesService!runningjobs!c!1/21/2008-10:48:28:: i INFO: RunningJobContext.IsExpired; found expired request
ReportingServicesService!processing!8!1/21/2008-10:48:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user.
ReportingServicesService!processing!8!1/21/2008-10:48:28:: w WARN: Data set 'ICParamAll': Report processing has been aborted.
ReportingServicesService!processing!19!1/21/2008-10:48:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user.
ReportingServicesService!processing!19!1/21/2008-10:48:28:: w WARN: Data source 'eConsole': Report processing has been aborted.
ReportingServicesService!processing!19!1/21/2008-10:48:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user. , ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: Report processing has been canceled by the user.
ReportingServicesService!processing!10!1/21/2008-10:48:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ICParamAll., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set ICParamAll. ---> System.Data.SqlClient.SqlException: Operation cancelled by user.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
--- End of inner exception stack trace ---
Any tip will be greatly appreciated.
I'm new to ASP.NET (I normally work with Windows Forms) and have installed the Club Website Starter Kit. I created an Administrators role and a user called "admin". When I run the project locally, everything works as it should - I can log in as admin and I can create new users.
I then copied the site to localhost (C:Inetpubwwwroot), but when I run the site from localhost, I can't log in (as admin or any other user); instead I get a message that says, "Your login attempt was not successful. Please try again."
Also, I can't create a new user. When I try, I get the following error:
Server Error in '/' Application.
Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I figure there must be a simple(?) explanation and solution for this problem, and ideally, some sort of step-by-step procedure that new users to ASP.NET can follow to configure a site - such as one of the starter kits - to work correctly. I can honestly say that trying to get this working has been an extremely frustrating experience.
If someone could help me out, I would really appreciate it. I've been working on this for two days and feeling I have hit the wall.
Thanks in advance.
Hi there,I am getting a real problem with ASP.NET 2.0, all i am trying to do is run a recovert password (using the login controls) and i got the following error.Does anybody know how to fix this? I have tried the SSEUTIL answer here and it didn't work. http://forums.asp.net/909168/ShowPost.aspxI also ensured that Network Services user has READ/WRITE/EXECUTE premissions on the directory below and that each file isn't read only and also that it inherits ACL from the directory which it seems to do..Bit of strange one this, it isn't created (and i am not using) a beta version of VS 2005 Pro... but a full retail version.The PC is the local PC with IIS 5.1 and VS installed... it is the one i am using for developing.. I don't need to copy my files to the IIS directory below as that is where i have created it and open it in VS 2005 from there..I did read that if you use IIS 5.1 then the user should be ASPNET ... but i don't seem to have that use but a Network Services user...Any help or guidance would be really appreciated... i have come to a stop stage and can't get any further..Thanksian
Server Error in '/igdotcom' Application.
Failed to update database
"C:INETPUBWWWROOTIGDOTCOMAPP_DATAASPNETDB.MDF" because the database
is read-only. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
System.Data.SqlClient.SqlException: Failed to update database
"C:INETPUBWWWROOTIGDOTCOMAPP_DATAASPNETDB.MDF" because the database
is read-only.Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Hello,
I am using this sql data source control.
<asp:textbox runat="server" id="txtFromDate" ReadOnly="true"></></asp:textbox>
<asp:textbox runat="server" id="txtToDate" ReadOnly="true"></asp:textbox>
--------------------------------->
<asp:sqldatasource id="dsClickInfo" runat="server" connectionstring="<%$ ConnectionStrings:activeConnectionString %>"
selectcommand="SProc_GetTransaction" selectcommandtype="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter QueryStringField="Id" Name="MerchantID" Type="int32" />
<asp:ControlParameter ControlID="txtFromDate" Name="StartDate" PropertyName="Text"
Type="String" DefaultValue="0" />
<asp:ControlParameter ControlID="txtToDate" Name="EndDate" PropertyName="Text"
Type="String" DefaultValue="0" />
</SelectParameters>
</asp:sqldatasource>
I abouve code txtFromDate and txtToDate are marked as readonly so sqldatasource is not able to get value from these controls.
How is it possible?
Please help me..
Hi all,
My SQL database has varchar that store names with special caracter like "René". The problem is when I try to get the data back from the database, the .Read() command from the SqlDataReader object is not working. In extra, it does not Throw any error????????
Please help me,
JR
Here is my task I am storing pdf's in sql server. I would like to retrieve the binary data from sql server and write the pdf content into an existing aspx page to the appropriate pageview section. What is the best way to handle this. The code works below but it loads a new browser with the content. I need it to appear in it's tabbed section in the original aspx file. Any assistance you can give me would be greatly appreciated.
Thanks Jerry
oSQLConn.Open()Dim myreader As SqlDataReader
myreader = myCommand.ExecuteReader
Response.Expires = 0
Response.Buffer = True
Response.Clear()
Do While (myreader.Read())
Response.ContentType = ("application/pdf")Response.BinaryWrite(myreader.Item("img_content"))
Loop