(And, yes, I am catching up on The Thread at 4 AM in my time zone. Late night server moves today.)

Lynn Pettis (10/3/2011)

---

Well, my two articles are off codevc.com. Now I just need to keep an eye on the two blogs on blogspot.com to make sure those come down.

Does...

parsayandan (10/3/2011)

---

we want do right and I ask today about this completely from my lawyer

and If your think was true I delete SCC data or data that have problem...

parsayandan (10/3/2011)

---

I ask in past from Google advertise team from content of this site and when he say to a site spammer

he tell me when you use a thing without...

Jack Corbett (10/2/2011)

---

Thanks for the congratulations all.

It's nice to be recognized, but I also know that when I've been in the room with MVP's and the people I've met...

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all the MVP's...

UnionAll (10/1/2011)

---

Thank you!

Convinced to store XML directly in a table.

A follow up question, let's say for example the XML file that's sent has 3 tags as below.

Always a blank field...

Store the document you send. That's more verifiable than anything else when it comes to audit trails.

If it's actually duplicates in the source table, change that to a subquery (inline or CTE) and use Distinct in it.

I made the necessary syntax changes to get it to lay out using Red Gate's SQL Prompt, but it really didn't help much. Made it more readable, but not...

All that is assuming the SQL engine you're connected to isn't local. If you have SQL Server on your workstation and are running the query on a "(local)" connection,...

Windows integrated security can only pass credentials to one other computer, not pass through one to another.

So, if you connect from your workstation to a server, your workstation passes credentials...

GilaMonster (9/30/2011)

---

GSquared (9/30/2011)

---

Yeah. Soon as I asked the question, I went and researched it. Short schema lock at the end of the process for Online if I read...

Matthew Joughin (9/29/2011)

---

I would say the way pioneered by http://www.StackOverflow.com is the best way, where responses are voted for, but you can only vote for a response if you have...

If you go to the properties on a flow (green or red arrow in the package designer), you can set it to check for values. If you run the...