dbcc inputbuffer(sp id goes here)

That will tell you the active or last statement. You can also use sp_who2 to see if it's terminated.

Then use the Kill (spid) command to...

Delete the data from the table then reinsert it.

What does the log say?

Is there any warnings thrown?

Is the task set to turn green on success?

Is there a clear Success path where something tells SISS that this is successful?

I was talking about a more general common mistakes article series.

Hey Jeff, that's a great topic for a couple of articles... can't wait to read those!

I hope you hired him on the spot! :w00t:

The fact of the matter is that once you can build the keyusing a set solution, you can also validate it using the same solution (might make for a darn...

Do I know a lot because I read a lot or do I know alot because I do a lot???

What was my first answer? >>> Try

It would have taken...

Joyeux Noel, bonne année et joyeuses fêtes.

I can't think of a better xmas gift to give for Jeff...

Let's go... post the specs and the code and see what we come up with.

What's the point of the left join in the query? I don't understand what you are trying to do there.

I've played in concerts back in high school... and if and when you hit the wrong note, you can't correct it without starting the whole thing over... quite similar to...

Ah!, good point Barry... so how about your mother!!!!

😀

Tssss,tsss, you had to go ahead and wake up the tigger... and I was hoping for a quiet xmas!!!

I bet a small dollar that this will be the new longest...

Still ranting...

the simple fact of the matter is that if he had bothered to start the install he would have known right away if he could do a straight...