Thanks for all your help with this. I was able rebuild the schema then import data. The data import failed where there were some orphaned rows and I was able...

so, I'm going to try this tonight and have been trying to research the best options. here's what i have so far (with some questions.)

step 1) create scripts for the...

Bummer. Any particular reason I should do this on 2000? I ask because I can work locally on 2008, but I have to work remotely on 2000...

What about rescripting the database from scratch, then DTS the data into the empty shell? I've read on a few different posts that this is a possible solution. Would be...

Hi Gail--

Okay, thanks. So, I ran the update on the 2k db, and when I ran dbcc checkcatalog, it returned no errors. So far so good.

I then restored the DB...

Hi Gail-- any more thoughts on this? what's the general idea behind the fix you're thinking of? thanks

As a side note, the reason I noticed the problem in the first place was because a simple insert was failing on the 2008 DB.

I run this on 2008

INSERT...

outputs in excel. thanks for taking the time to help me with this...

-J

OK, I'm not sure this is right...

I ran:

select constid, fkeyid, rkeyid, rkeyindid, keycnt, forkeys, refkeys, fkey1

from sysreferences where rkeyid

in (2092586543,964914509,27147142,1778821399,2092586543,1904061869)

(do you need other columns? when i selected...

Here are the results... (Why would there be fewer errors here than in the 2008 results pasted above? )

Server: Msg 2513, Level 16, State 14, Line 1

Table error: Object ID...

Thank you for your responses. I found a back up from 10/08 and the errors are still there, so the problem's been around for a while.

In any case, the application...