Only 8.5 more hours to go.....

Maybe I'm missing something but...where is Part 1

Allan

Sorry there is no query. I export the table using

bcp DB1..PIPE_STUFF out \\OtherServer\Data\pipestuff.txt -T -n

then import on other server by

bcp DB2..PIPE_STUFF in \\OtherServer\Data\pipestuff.txt -T -n

BCP is doing all...

I have it working now. I had to go into internet options in control panel and set outlook as the default mail client. Somehow outlook express was the default....

Allan

Thanks guys,

I needed to go to control panel->inernet options->mail and set outlook as the default mail client. It was still set to outlook express.

Thanks Again,

Allan

I had this problem as well and I think it was somewhere on the Microsoft site I found this advice. 1) Script the database and turn on "Script only version...

Just a thought...

You could output the text file in xml format and use sp_xml_preparedocument to get the file and and SELECT....OPENXML to retrieve the value. It might be simpler than...