This is a hack but it will do the job : run subcription with default name.

Create a windows task that renames the file with for exemple today's date (might have...

What did you try and what is wrong with those results?

How do you define the first guy??

SELECT * FROM Source INNER JOIN (

SELECT Manager_id, MIN(emp_id) FROM Source GROUP BY Manager_ID

) dtFirst ON Source.Manager_id = dtFirst.Manager_id and Source.emp_id = dtFirst.emp_id

inner join...

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...