Add the -c switch to your command line so that it copies out the data as character data.

bcp CPPhil.dbo.vwInput_Client_YO1 out Client_YO1.dat -n -c -t, -q -SLYRA\SQL2005 -T

He definitely has been spreading his wealth around. He does a lot here in Washington state that never makes the (inter)national news. And yet, for all of his philanthropy, he's...

What is your bcp command? What does it look like in Wordpad?

Sounds like the SSMS installs are from different builds or service packs.

I really liked Encounter with Tiber by Buzz Aldrin and John Barnes

The story isn't exactly the most original, but it was really well written and interesting.

Nice idea, skrilla!!

This isn't something I would recommend trying out, but in a similar situation in a merge replication environment, I was able to stop the merge agent quick enough...

Well, who can resist free soda?

I hope so. It will make me look better by comparison.

I just sent my resume to jobs@zillow.com. I am currently the dba and head of the Data Management Team at Real Tech LLC in Bellevue, WA.

I hope to hear...

Try adding a USE statement to the dynamic SQL.

Do you have the data files and log files on separate drives? This should improve performance considerably.

Also, I like to put the tempdb on a third drive all its own.

Lastly, have...

Amen!!! I recently turned down a dba job in the LA area that would have paid me around 30K/year more than I make in the Seattle area, but a comparable...

I did not say that they "should not" be part of replication, I said that they "are not" part of replication. Indexes will only be on the server that you...

Your question isn't clear. What exactly do you need guidance with?

It depends. Adding indexes always has some negative impact on performance of inserts and updates (of which replication does a lot). So it depends on the index.

The main thing to...