Don't lie about your experience, with something as technical as SQL it will become apparent VERY quickly how much you know and it only irritates people when they find out...

I would tend to agree..

CEWII

Keep in mind this is only relevant for SQL logins, domain logins will still follow the domain policy no matter what options you try to set.

CEWII

Henry covered the one thing I was going to point out, don't over-commit the resources, each node needs to have enough resources in reserve to cover all instances on a...

That was exactly the solution I was going to suggest right up until I read your response...

CEWII

I seem to remember running accross this before.. Create another connection that exactly matches the existing connection (except the name) the lookup uses and then change the lookup to...

I can't think of a good way to do this in the DB, but good source control policies can help mitigate this. Also, your code should be periodically reviewed...

So what format are you looking for and what do you want to do with it?

I just wrote a custom dataflow task that does something like this, and it could...

You could try a DDL trigger, but I would be VERY careful because you could get into a situation where YOU can't delete the trigger and then the server is...

How about the stored procedure be given a bit more intelligence. Add a section before the insert that does an existence check, if it already exists then you are...

I found a great deal wrong with this article, but I think GilaMonster probably covered most of my objections the best.

I think the sugestion that this should have been peer...

You explained that way better than I was...

CEWII

You are welcome.

CEWII

I'm not sure I satisfied the "elegant" requirement, more the "it works" requirement..

CEWII

For SQL logins especially in 2000 there is nothing, in 2005, I'm not sure. For trusted/windows logins if the user does something that gets them locked out at the...