Thanks, Michael. I know what the fixed server roles do. What I'm trying to figure out is what they might not cover that would be necessary for a DBA who...

Glad I could help.

Do you realize your specified field terminator is not the same as what's in the file?

You're specifying a comma. The field terminator appears to be a semicolon.

EDIT: You may also...

Sorry I wasn't able to help you further.

Halloween

You really need to find out why the backup is being blocked. Check your error logs, check the default trace, run a server side trace, whatever you have to. But...

pitcher166 (10/25/2010)

---

Dynamic sql is not bad in any case. You should try dynamic sql perhaps if the execution plan inside a proc is suboptimal. With dynamic sql the statements within...

Pam,

Is there a reason you can't use SSIS to do this move?

And now it's time to start the upgrade discussion at my workplace. I think we might only be getting the regular version. I'd like to get R2 if I can,...

Yikes. So you have no one to go to for answers? That sucks.

I'm working TFS in BIDS 2005, so there's probably a lot of setup in yours that I'm missing....

I'm tempted, but it's too easy to fall into the "My thread is most important so I must link it to "The Thread" " mindset. I don't want to encourage...

Whisper brings up a good point. Any anti-v solution you use will need to exclude your data and transaction files. If it doesn't, it'll bring your server to its proverbial...

Unfortunately, I've never seen that error. Try googling it with "Team Foundation Server". Lots of articles come up. See which one fits your situation.

Also, do you have a TFS admin...

Pam,

Just a note. Virtual Servers make no difference if they're using the same SAM setup. You need to find out if they are.

500 records should not be causing 100...

Do you have the same number of columns in the table as are in your file?