Environment: SQL Server 2000 + SP3, Windows 2000 +SP3
I am running a storedprocedure through Java and got the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (torn page)
detected during read at offset 0x000000254ea000 in file 'd:\Program
Files\Microsoft SQL Server\MSSQL\data\ServiceDB_Data.mdf'.
Can some body help me in solving this problem. Also I found one of the table
which is being accessed by the above storedprocedure, is not giving back any
results, when I make direct query in the Query yzer (e.g. Select * from
Table123 where 1 =2 ) and the query is running for ever.