without seeing your script, here is a common issue:

if you ALTER a table by adding a column, and then try to INSERTfeaturing that new column , an error is raised unless a GO occurs after the ALTER

if you run each statement separately, no problem...run this as a batch, and you will get an error:

create table #test( testtext varchar(30), MyRand varchar(5) DEFAULT(REPLACE( STR( ABS( CHECKSUM( NEWID() ) ) % 10000, 5 ), ' ', '1' ) ) )

alter table #test add whentext datetime

insert into #test(testtext,whentext)

select 'apples',getdate() union all

select 'grapes',getdate() union all

select 'bananas',getdate()

select * from #test