I'm waiting for the Average DBA Competition. I'll nominate myself for that one.

Paul White (3/12/2010)

---

It looked like spam to me...

Please do not cross post. Please post replies here.

GTR (3/11/2010)

---

Carl Federl (3/11/2010)

---

MS has added some "Denial of service attacks" protection (SynAttackProtect setting), which can cause this message. See "Troubleshooting: Connection Forcibly Closed" at http://msdn.microsoft.com/en-us/library/ms187005.aspx

Also see "Avoiding TCP/IP...

We are using TCP for...

Jack Corbett (3/11/2010)

---

Do you have your network and sever admins involved as well? It doesn't seem to me to be a SQL Server issue.

I'm not sure that you'd get...

Okay, still getting this error and we are now in production. I'm thinking I should set up a server-side trace to see if we can catch anything that may...

It could be me, but the execution plan for the UNPIVOT solution still looks a lot like the execution plan of the CROSS JOIN/multiple UNION ALL solution. I'd be...

Using templates or code snippets, it's basically write once use many times.

Most definitely! Served by the Master himself!! :w00t:

Don't know, how big is Jeff's house? 😛

[font="Comic Sans MS"]Party!! (At Jeff's)[/font]

[font="Comic Sans MS"]Congratulations on passing 20,000, Jeff!![/font]

Again, test this scenerio in your test environment. That is the best way to determine what will happen and to determine what you need to do to mitigate the...

Not having your SSIS package in front of me, hard to say. My suggestion, test it for that scenerio.