You can try to export using bcp...

We use this sproc, don't know where i saw first

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72841

http://www.eggheadcafe.com/software/aspnet/31906881/importing-saltable-to-exc.aspx

DECLARE (We made some modifications to use it 'cause having rare...