Tim

Not sure how easy it would be to catch something like this but the sequence roughly goes

move column _Owner up a lot,
drop column _Owner,
add column _Owner as a different datatype,
move column _Owner up a lot,
click the go button and get told _Owner doesn't exist

I'm sure there were other bits in there, may even have been another add/drop _Owner sequence but even a few seconds after its evaporated from my short term memory.

Roy Lambert

Roy,

<< Not sure how easy it would be to catch something like this but the
sequence roughly goes >>

I'll look into this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Not sure how easy it would be to catch something like this but the
sequence roughly goes >>

Unfortunately, I can't reproduce this here based upon your initial
description, so there must be something that I'm missing.  Did you have any
RI defined that was referring to the original column ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Unfortunately, I can't reproduce this here based upon your initial
>description, so there must be something that I'm missing. Did you have any
>RI defined that was referring to the original column ?

Nope.

Roy Lambert