Tried using the except verb but got:

insert into LIVEDB.dbo.APHEXPF

(aph_comp, aph_vend, aph_type, aph_id, aph_padd, aph_acct, aph_post_co,

aph_desc, aph_amt, aph_proj, aph_pline)

select c.aph_comp, c.aph_vend, c.aph_type, c.aph_id, c.aph_padd, c.aph_acct, c.aph_post_co,

c.aph_desc, c.aph_amt, c.aph_proj,...

ok that is a typo on this forum when run the syntax check on the query it says 'Command(s) completed successfully.' but when i run it i get

Msg 512, Level...

my original post explained it

in mssql 2008 or lower that command worked without having to setup sysmessages for it. in 2012 it no longer works. i originally had written some...

well that answered my question. doesnt look like there is setting/configuration change that would make it behave like the older versions. so i will be changing up scripts in the...

just an old format i have been using since sql 7/2000

the 22004 was just and arbitrary number that i chose.

if you put the line i supplied into sql 2008...

not a regular thing but more than just a one time issue. i have about 50 customers to run this for.

of those 50 about 30 will have large amounts of...

Well i really do appreciate all the info for changing the collation of columns, but like i said i have already written a delphi app that already does this. My...

pretty much use the looping process i was looking for something along the lines of...

alter table xxxxx

alter column yyyyyy char(10) collate aaaaaaaaaaa,

...

Thats what i needed thanks again for the info/example. worked great.

i got this taken care of guys thanks for all the info.

i don't have the exact syntax available right now but in my application it is all working fine.

So....

Thank...

thanks...

Thank you all for the extra information. I had the client increase the size of the C drive/partition and got past the installation issue.

Again thanks...

that will work for what i need. now i can just use that information to link the 2 tables missing rows.

That's pretty much what i have for inserting all records from table1_save back to table1 after deleting all the records from table1, with the exception of the test on the...

Thanks for the extra info guys. i really appreciate it.

I am pretty sure that i have enough info to complete this project.

Again Thank you very much.