AFAIK there is no way to make specifications like nullability when you are creating a table as you are. I work a lot in Oracle and create a lot of backup tables using 'Create Table x as select * from y'. That format copies over the columns nullability.
Perry
>Hello,
>
>I am attempting to write a select statement in SQL Server Query Analyzer which will result in a table being added to my database . That part works but all the columns are checked to allow nulls.
>
>Select cast(0 as integer) as logid,
>cast(0 as integer) as ErrNumber,
>space(2000) as ErrDescription,
>space(200) as ErrSource,
>cast(0 as integer) as ErrLineNumber,
>cast(0 as integer) as Pubid,
>cast(0 as integer) as UserID,
>getdate() as ErrDateTime into pp2k_progs.dbo.errlog
>from pp2ks_new.dbo.errlog
>
>I've tried playing around with the SET ANSI_NULL_DFLT_OFF settings but that only seems to work with the alter table commands.
>
>Any assistance provided would be greatly appreciated.
>
>Sincerely,
>
>Michael Brennan-White
(On an infant's shirt): Already smarter than Bush