Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2006-08-09 : 23:10:26
|
| Hello Experts, I am using the sql server 2005 SP1(9.0.2047)I am executing the Select statement which joins about Six Tables with NOLOCK Hint.It spends about 15 minutes and then gives this error.Server: Msg 601, Level 12, State 3, Line 14 Could not continue scan with NOLOCK due to data movement. I tried the same query with TOP 10 Clause.The Same Error.Any help would be appreciated.I am sure no one is doing any updates/Inserts in the Database.I revoked all the permissions and then Tried.Thanks!Raju |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-08-09 : 23:19:10
|
| I would try it in single user mode rather then revoking the permissions. Also post the query. |
 |
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-08-09 : 23:29:30
|
| Thanks for your advice..I tried in the single user mode and this time it returned this error.Msg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xbb98f3e; actual: 0x11379379). It occurred during a read of page (1:3176424) in database ID 48 at offset 0x0000060efd0000 in file 'H:\MSSQL\Data\Warehouse_Data.MDF'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.I will try after running the dbcc commands .Thanks again!Raju |
|
|
|
|
|
|
Query returns the weired error