Thanks Steve.. am I right to say that you can encrypt the whole database in SQL 2000?

THANKS Andras,

If I do this (change the compatibility mode) will it effect my SQL2005 box?

For example can I apply updates and service packs without any issues?

I'll look into bcp .. thanks Jeff:)

The emails in the file are padded with spaces making it too big for field

thanks Kent..

I would have thought there would have been an easier way than that. Several sources say there is

a BEFORE keyword with the ALTER TABLE add statement but...