I found a solution on http://technet.microsoft.com/en-us/library/cc627491.aspx

that did the trick. If you simply drag a data item over from your dataset you don't get this option, but...

I copied the corrupted database to another server, then ran

DBCC checkdb ('VertexProd', repair_allow_data_loss)

and the results look promising.

A query on the VertexProd table shows data from the...

This final line of the results from DBCC CHECKDB -

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

Can someone interpret that for me? ...

We're bringing in a DBA to evaluate and check this out for us, I'll make sure they review the info you all provided. Thank you so much...

GilaMonster (10/11/2012)

---

You can, but unless you have log backups, you're looking at losing all data since the backup that you use to restore. Is that acceptable (potentially going back to...

Should I start with the most recent backups and go back in time until the dbcc is clear?

We have backups, but I don't know how to identify when this problem started happening, and therefore which backup to use. This table is queried once a month to...

Full results of DBCC CHECKDB('VertexProd') WITH NO_INFOMSGS, ALL_ERRORMSGS shown:

Msg 8928, Level 16, State 1, Line 1

Object ID 437576597, index ID 0, partition ID 72057594039894016, alloc unit ID 72057594043891712 (type In-row...

This works great, thanks!

I'm going to use a temp table and convert the text field to a varchar(max) field, update the field in the temp table, then update the original table with the...