Does the table exist? Before you do the insert, try select * From #Test.
Are you creating the table and the building up a string with the insert syntax?
If so, this should not work.
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!