Good points... Maybe a faster solution would be to do it like EM does it. Create a new table with the correct datatypes, then reinsert the data, drop the...

Why not just run the alter table command on all the columns at the same time (just throwing ideas, I never had to do this)?

How do you reinsert it???

Why can't you keep it in place?

I just don't know how to fix this one... I'll keep listening in case something comes up.

The real question is : Has it been deleted or not created in the first place. The parent of the relationship must exists before any child can be added.

command timeout??

Is it a straight select of the column or there's some manipulation of it?

Seriously :

Select left(col1, 3) as col1,... into temp_table

copy the script from em, use the sp I sent you to make the insert statements. I care about my job...

CREATE UNIQUE NONCLUSTERED INDEX IX_Name ON dbo.TableName (col1, col2, col3, col4)

I run it under local too here. I don't know what else could be causing this.

What's the error message you are getting?

We need the DDL, sample date and sample results to answer this.

I tried that and it works for me.

What does this return?

Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')

And please post sample data too along with the required results.

The idea is to make sure that each selects have the same datatype/length in the union... This is most likely where the problemis coming from.