Thanks so much !!! Both options work great. Exactly what I needed!!!

Juanita

Thank you!

THANK YOU SO MUCH !!

That is exactly what I needed !!

Juanita 

okay, thanks a bunch !

Juanita

HI. Me again, I did a select * so I could see all fields for that login. there is a field called STATUS. Would you know what that field represents?

Juanita

You have a point.. well i'm just going to delete them and I guess if someone needs them they'll HOLLER !!

THANK YOU for all your help !!

Well it was all done in 1 shot it looks like back in February. I don't think logexplorer will help me in this case. But thank you so much for...

Thank you I will try the select stmt. But I do have logexplorer. I have not used it much but I guess now is a good a time as any.I...

Thank you everyone for all your help and suggestions. I learned alot from all of your input!!

Juanita

HI. I would only drop the original table if the massive update was a failure and would want to put the table back to its' original state. I'm just doing...

Hi. Actually I am taking a snapshot before a big update. So the create and insert would be fine. But let's say I had to do a quick restore, Since...

thanks. that will get me started !

Juanita

HI all,

I finally fixed the problem. it was that the file that was being written to had the key as an auto number. once I removed that property it was...

One more note, what really confuses me is that if I change the ownership of the user to database owner, the problem doesn't occur? does being a database owner override...

Luke, Thank you. I'm checking that right now. I know the original tables key is an identity field but I didn't make the key in the backup table to be...