We are trying to restore current data to a backup that is a month old using the latest ldf file.

I ended up running the whole thing through Integration Services and just made a package.

I prefer to script things out because they require less system resources to run. But...

I got a solution to the collation issue.

SET @String = 'bcp "SELECT * FROM ULTIPRO_TMFHS.dbo.qry_Healthstream" QUERYOUT ' + @Path + @File + ' -c -CACP -S ' +

Jeff Moden (7/8/2009)

---

mckinnj1 (7/7/2009)

---

I am trying to use a bcp in 2005 and the file is continually going out as Unicode when I am trying to define it (or at...

/bump

/bump

/bump

I am trying to use a bcp in 2005 and the file is continually going out as Unicode when I am trying to define it (or at least i think...

Disregard!

I figured it out.

+CHAR(13) + CHAR(10) is not necessary when using bcp. I removed them from the script and ran the bcp with -c and it worked great.

Thanks me!...