quote:

---

If you use a go after the alter table it should work ok - eg:

create table #dummy

(

PERSONAL_REFERENCE varchar(10)

)

insert #dummy ( PERSONAL_REFERENCE )

values(1)

alter...