Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB.
/anc_SQL/report_anc8.asp, line 91
โค้ด ASP ที่เขียน ดังนี้ครับ (ภาษา ASP+MS SQL 2005)
Code (ASP)
Sql="select age_nickname,sum(convert(real, replace(p_g2,',',''))) as b_sum1 from ClassAgePrb where p_date='"&StartDate&"' and ((m_job Like 'P-%') or (m_job Like 'M-%' and err_msg4='ผ่าน' and err_msg1 Not Like '%ต่อ%')) group by age_nickname"
Set rs1=Server.CreateObject ("ADODB.Recordset")
rs1.Open sql, Conn, 1,3
Load balance : Server 05
