It does look like the problem existed on the 2000 server, just not as obvious. I'm not sure how it happened though.

Thanks everyone for the help. It looks like it will not be a simple fix :crying: .

Even though I still have the tables stored on our SQL 2000 SVR...

Thanks Steve.

I went ahead and ran that statement. I'm assuming that will prevent any future tables from being marked as system, but unfortunately the existing tables did not change.

I thought I would go ahead and add a couple images showing whats going on.

This shows my tables as both system and non system tables.

This shows where is_ms_shipped is set...

I tried a backup and restore but the tables remain as system tables.

I guess if all else fails I can export the data to another server, remove the...

They do have a type of U and a type_desc of USER_TABLE but is_ms_shipped is marked as 1 and I believe it should be 0. I realize that attaching...

I am a programmer and have been doing this for years. I would like to say that a great programmer is someone that is fixated on how simply their...