OK, as has previously been requested, please will you post the definition of the stored procedure you mentioned?

John

Unfortunately, your knowledge...

Sounds like you have a unique index with IGNORE_DUP_KEY set to ON. You get this warning when, and only when, you attempt to insert something that would violate the...

It's one of four very similar solutions that have been posted. The only ways they differ are as follows:

(1) Some use common...

Who is Bueller?

Why don't you put the file in its own folder, then you don't need to worry about the file name - just look for any file in that...

That's rough. What are non-technical people doing even looking at code, never mind imposing standards for it?

John

Maybe you could get the powers that be to have a look at the article I linked to? If I remember correctly, the thrust of the argument was that...

There was an interesting discussion on comments recently here.

John

I know it's a matter of preference, but I'd rather have any complexity tucked away in the CTE definition than in the body of the query,...

Does this happen every time, or did it just occur once? Do you have any jobs or triggers on Server B that might remove the indexes?

John

Clearly not useless, even if your personal preference is not to use them. And no more or less complicated, in my opinion, than...

Is this repeatable, or did it just happen once? What statement(s) are you using to restore the database, and what statements (if any) do you run after it?

You appear...

Well, it was on the phone, so maybe I just heard what I wanted to...

I've had developers gasp in wonder when I've shown them how to use code similar to Jamsheer's and thus...

Good question, thanks. I'd have liked to have seen in the explanation why the third and fourth options were wrong, something like this:

Option three is not correct because the...