If you haven't verified what, how do you know it's blocking at all? Are you getting a deadlock error? What messages are you seeing?

Sp_who2 shows blocking SPIDs and you can...

Actually, this other response brings up a good point. What exactly is the proc blocking? Or being blocked by?

It's not a bad idea, but the problem is, you lose all your history going forward from the point of backup.

A slightly better idea would be to export the TABLE...

Ah, I thought it was something specific to the code that you could point me to.

CirquedeSQLeil (5/7/2010)

---

It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and ask...

Could you share so that future readers of this thread know what to look for?

You're quite welcome.

Depends on how that...

So far as I know, and I could be wrong, you can't Fuzzy Group without a basic Fuzzy Lookup. Which tells me SSIS has a built-in Lookup feature on the...

Is the user there or the login there?

There's a difference. If the login isn't mapped to the database or mapped improperly to the database, then you'll encounter this error.

"Improperly" is...

Please don't take this the wrong way...

Beware the easy out....

This code hits one of my major pet peeves, which probably doesn't contribute much to your problem but certainly doesn't help it either.

Allow me to point out a few...

Elliot is...

Edit: Misread original post. Deleting this comment and looking for a better solution.

I've never actually seen that error before, and I've used the RetainSameConnection property. But never...

Is this query yours or does it belong to the vendor?