Hi Eric,

True enough verifying the columns through Information Schema is a good move for sure.

Thanks

Hi Eric,

I had approached it this way initially. I had a script ready and everything. But thought that maybe it would be cleaner to delete/less prone to error and...

No problem. Yeh definitely thanks to Steve too. Appreciate it lads.

That's great Grant. Thanks so much for the information. Really helped.

I can't see how to mark you as having answered my question. Do we do that on this site?

But...

Hi Guys,

Thanks for the replies. That's the sort of thing I was looking for. What I would like to know if though, you mentioned using the snapshot, from the...

Thanks guys I have found the answer by myself. If you go to Tools > Options > Designers > Table and Database Designers

and deselect the Prevent saving changes that...

It's looking like a long road ahead. Jim I'll try out your validation idea, it sounds like my best option.

Thanks guys for all of your help, much appreciated. 🙂

Hi,

Yes plenty of testing ahead. No I don't think there are any clustered indexes. It has just been a matter of, theres a table. No consideration on how it...

Thanks for that Jim. Yeh thought that might be the case. I Was hoping that there was a magic wand out there.

It's not a vendor db just an old...