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 |
|
tanima
Starting Member
1 Post |
 Posted - 2009-11-03 : 08:05:18
|
| Hi,I am running a query on our database server, SQL Server 2005'select * from DAuditNew (Auditdata for out application), however when I attempt to sort this by dateselect * from DAuditNew order by Auditdate desc, I get the following error message,‘Msg 7105, Level 22, State 6, Line 1Database ID 5, page (1:4404589), slot 36 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.’DBCC CHECKTABLE was run by the DBA and there were no problems detected. Was wondering if you could help me on this?Thanks,Tanima |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
slot 36 for LOB data type node does not exist erro