I did check and verified that some of the primary keys were lost, or I think I had problems re-attaching at that time. So, to restore the original primary keys...

I detached the database created copied of the database files and them re-attached.

If I add an identity column to the current table, will the same order be retained. As of right now, order is important. If order was retaine then I would...

Thanks all. I will use the suggestions above, and yes, if you are wondering why someone would construct such a table, I didn't, I inherited it from some unknown 'deadhead'...

Thanks all. Just a table with one column, 'email' .... no identity column.

Another quick question, do I move all other relevant data (that returned by a select), over to the new table(TESTCASE) if I want to return it as well as the...

Don't really understand what you are suggesting David. Wouldn't that create the same problem as before? Cannot update values that are primary/foreign key values in multiple tables.

Thanks all. I will be suggesting to the client to upgrade to SQL Server 2000 (especially since they already have a MSDN subscription including the newer DB) and then proceeding...

Thanks Noeld. Great information. If I do migrate the database to SQL Server 2000, is there a set of procedures that I should follow before doing so? Any further information...

Thanks Noeld. What is your recommendation for my situation?

Is there code or an extended stored procedure for doing this?

How can I confirm that the key for each table is a primary/foreign key value?

Yes, if you are suggesting to drop the relationship(s) and then perform the cascade update.

Are there high risks to dropping the relationships on the related tables? I am always hesitant to do that, because of problem in the past, especially with older systems. This...

Sure Wayne.

I have several tables in a database where a column, patrol_no is the only primary/foreign key in each of the tables. Recently, a request came in to update the...