Actually, this not true. Even without FK's there are techniques to discern the relationships...

Glad we could help.

At the beginning you say "Deadlocks" but at the nd you say "blocking". Which is it, or which is the problem? Any solution to prevent deadlocks is likely to...

it's really not possible to give a good answer to this question without looking at some examples oif what you are seeing as "the problem". In particular, wht do...

For those who may not know, the "Mike C" above is actually the amazing Michael Coles an expert in this area (see here: http://www.amazon.com/Expert-SQL-Server-2008-Encryption/dp/1430224649) and a great guy to boot....

Glad I could help...

Assuming that you have setup your configuration file in your package to be an indirect configuration (i.e., controlled through an environment parameter), then create a SQL Agent job step for...

Then you want to define a "Linked Server" to that other server and use a four-part name.

I am not really following your question. What are you trying to do?

I've never been in favor of any kind of blacklisting feature: too easy to get on it, too hard to get off, way to easily abused.

I think that some simple...

Check out "DB Mail" or "Database Mail" in BOL. It is a much faster, safe and more robust replacement for SQL Mail and uses SMTP so that you do...

Hey, I just noticed that I broke 8000! Woo-hoo!

So let's see,... oh, Lynn just passed 9000?!?

OK, ok, ... so I am just 5,300 points behind Gail? And...

that's how I do it all the time. I even have some procedures to automate it.

Sure, it's easy. Here is an article from my blog that demonstrates how to do it.

The article is actually on Multi-Tenant databases, but the basic idea is the same:...

I agree with Tim. I leave the loaded data in the staging table after the package run and do not delete it until that next run. Tha way...