Hi,

the point is the creation of a table column with a constant. - eg 1 or 'A' -

in this case a not null constraint is added to this column when select .. into is used.

on msdn nor the books online i've found why this happened.

learned that by getting errors 😛

kind regards Matthias