Side note. Make sure they run a DBCC CLEANTABLE on the table in question after the removal to deallocate the extents associated to BLOBs. It needs to be...

Additional information. SQL 2k8 R1 SP1 talking to SQL 2k5 does not fail properly.

SQL 2k5 talking to 2k8 R1 SP1 DOES fail properly. I'm going to upgrade to...

Brandie Tarvin (1/12/2012)

---

Evil Kraig F (1/11/2012)

---

Brandie, do you have any extra information on what type of timeout it is? Is it a lock timeout, a remote query lockout, a...

Can you describe any transformation components occurring between the source file and the OLEDB destination? Also, can you check the field size settings in the advanced component of the...

You cannot completely stop selects from shared locking unless you use a read uncommitted transaction level or the NOLOCK hint. You also can't stop lock escalation.

However, this brings us...

Heh, New Guy on the block I guess.

Ctrl-F5 is my friend. Where'd I typo?

I want to worry and keep in my head the object model and the inter-communication and...

Grant Fritchey (1/12/2012)

---

SQLRNNR (1/12/2012)

---

What exactly...

Where's the beef?

Gifts

UNION ALL with a static data column in each statement to say which count...

For giggles, try an OPTION (MAXDOP 1) on the query.

To attach the .sqlplan, rt-click on the execution plan. Save execution plan as... (first option). Should pull up an explorer...

We'll try...

steve.anderson 7639 (1/11/2012)

---

Will a group by eliminate the old values? In this case, I have several revisions (A, B, C... etc...), and would only want C to show up...

Already responded. I'm waiting to see his answer before continuing.

The header is what makes this more difficult because you can't pre-pend a text file target....