I get this error occasionally also. Same arrangement, SQL 2000 SP3. Usually this indicates that one or more indexes on the rogue table are corrupt. By running a dbcc dbreindex,...

You could take the results of the stored procedure and insert them into a temporary table. Then you can query the table yourself and get the columns you want.

Eg: spProc...

The dbcc shrinkfile command should also work for your datafile/mdf also. It will probably take a while, but it will shrink the file. All you would have to do is...

I may be off base, but if you are using full logging on your database(I am not sure if you are or not), the log will remain intact until you...

you could write your backup file to a common location, and write a service or job on each backup machine to grab the file and restore it. Copy the job...

If you are having problems with the disk signature getting out of sync, try using the following command line:

dumpcfg -s 865dda44 8

the dumpcfg part you should be able to download...

If you are stuck with having to use a cursor, then making them read only and static should help. You would have to test it for your situation, but I...

Does your maintenance plan run a dbcc checkdb or checktable? It sounds like it is running one of those process with a parameter such as repair_rebuild, repair_allow_data_loss or repair_fast. In...

Thanks for both of your input. I found the thread Jeremy suggested early this morning. I think what I will end up using is an insert into a separate table,...

I have used this option a number of times and had success with it. Sometimes performance improved by a factor of ten. It is something that needs to be tested...

I think you would still need to have the statement Option (keepfixed plan) at the end of each statement. That tells SQL Server to use the previously established execution plan...

To reduce the recompiles, try adding

option (keepfixed plan)

at the end of each sql statement in the procedures.