usually a dbcc dbreindex command will resolve the issue. error probably is with the clustered index as indicated by indexID 0. look for the name of the index on...

is the new server going to acquire the properties (ip address, server name...) of the new server?

really a strange case. RID n:nnnnn error\ index chain error should have been generated when checkdb\checktable was executed.

anyway, thanks for the info

Since ur using 3rd party util, better verify it with your vendor whether their interpretation is the same. I am not sure whether your vendor is using SQL Server...

try using the bcp utility.

bcp out the table into the flat file, drop the table and recreate it on the second filegroup, then bcp in the file into...

actually you can do your own maintenance jobs. you will notice that every time you create maintenance plan using the wizards, it creates one job for backup, integrity checks,...

quote:

---

Two prblms: When I insert via a begin tranx block, one of my tbls t_report is not getting their record inserted. ...

try using TextCopy cmd to load the document. You can schedule index\reindex on the text cols

I dont think this will work in 7.0 though I have not tested it yet. sysaltfiles in 7.0 doesnt contain user db info.