MSSQL Data View Problem

[halshaikh]

I have a table called SwipesPermenant , this Table contains 15 feilds, and about 60,000 records.
before it was viewing data with no problems.
but now it says the following error when I try to list,update,del ete, only truncate command is working with this table.
the command:
update SwipesPermenant set employeeid='has ra' where employeeid=''
result, some data has viewed in the grid with the following msg;

Server: Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:19216) in database 'GoysTime' belongs to object '0', not to object 'SwipesPermenan t'.

Connection Broken

[r035198x]

I have a table called SwipesPermenant , this Table contains 15 feilds, and about 60,000 records.
before it was viewing data with no problems.
but now it says the following error when I try to list,update,del ete, only truncate command is working with this table.
the command:
update SwipesPermenant set employeeid='has ra' where employeeid=''
result, some data has viewed in the grid with the following msg;

Server: Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:19216) in database 'GoysTime' belongs to object '0', not to object 'SwipesPermenan t'.

Connection Broken

Moved to MSSQL forum

[Jim Doherty]

I have a table called SwipesPermenant , this Table contains 15 feilds, and about 60,000 records.
before it was viewing data with no problems.
but now it says the following error when I try to list,update,del ete, only truncate command is working with this table.
the command:
update SwipesPermenant set employeeid='has ra' where employeeid=''
result, some data has viewed in the grid with the following msg;

Server: Msg 605, Level 21, State 1, Line 1
Attempt to fetch logical page (1:19216) in database 'GoysTime' belongs to object '0', not to object 'SwipesPermenan t'.

Connection Broken

Sounds like you need some maintenance routines on the data.Do you have a database administrator? it might be a question of page split fragmentation. Check out the SQL server commands DBCC of which there are a whole host of them designed for database admin maintenance you might want to start with DBCC CHECKDB command

Look these up in SQL Servers standard help Books online (BOL)

Regards

Jim :)