How exactly are you planning on applying parallelism with this source table?

I see that you say you want 4 different Sources, but what will you be doing with these...

Are you trying to autogenerate a number during your insertion or pull the last identity field that was in that particular table?

These are two different tasks and require two different...

Depending on how busy I am, I do one of two things.

I either pick posts from the daily newsletter to respond to or I go into the forums directly (especially...

Rohit,

He already knows all that. He's trying to automate the copy process to a secured network drive and he refuses to listen to any of our advice on how to...

Andy Warren (12/29/2008)

---

Sorry, one more point - if you tag every post with a version, with a little work you can let users select which view they want - do...

I like the idea of compressing the forums down and having either a checkbox or dropdown list on the Thread Header / Title that asks for a version. This way...

I think I've fixed the line & title problem. Could you take a check?

I'll work on the image to the left when I have a breather (wrote 20-30k worth of...

Actually, it occurs to me to wonder if you have a link in some other table from UserID to UserName?

If UserName is not in any of the three tables...

I don't mean to offend anyone but...

Why does everyone insist on putting this check in the WHERE clause? It's messy and a Where clause usually complains when you try and...

Just an FYI. If using a variable is not an option because you're trying to do a set based conversion, then you can always use a CASE statement with a...

There is another option, though a very old option and not very pretty. Only use this if you can't convince the designers to use 2 separate columns in the main...

DOH!

I went back and checked our accounts after reading the Microsoft fix bulletin. Sure enough, different ReplyTo addresses than what's in the account name.

Fixed that and it still didn't work....

Nope. The SQL Agent Service restart didn't help me.

Darnit. This is annoying.

Well, we'll see if the restart works. I won't know until Monday.

Truthfully, though, I doubt this will solve my problem. We've failed over our cluster a number times since this...

Looking into this a little more, I finally opened up my job log and found the following error:

Files NOT Uploaded. Reason: System.Net.WebException: The remote server returned an error: (501) Syntax...