Brilliant article.

Only one thing which is a bit of a shame - this only works if the SP is execute as owner, not if it's execute as caller.

As a result,...

I'm afraid your questions are beyond me... Maybe someone else can answer them.

Sorry,

Rachel.

It will show a row for every tracer token which has been added. According to BOL the information gets cleared after the history retention period of the distribution database....

The BOL page with the meanings of the formats is the only one I keep in my favourites.

Aren't SSC points better than a cash prize?! 😀

Nice question - really gets you thinking...

OK, this is where we've got to now.

The account used to install the SCCM software needed to have sysadmin rights, otherwise it wouldn't install because it failed when the prerequisites...

The prerequisite check on the installer fails unless the login has sysadmin rights. A subset won't do.

We're going to try and do the install then remove the sysadmin rights...

In case anybody's interested, I've now done this using tracer tokens.

I have a SQL agent job to insert a tracer token for the publication at regular intervals. If the...

Not sure if this is quite what you wanted, but you can tweak the query in the article to add in the name of the publication and the name of...

I think you're all being rather mean to Derek - his was a perfectly reasonable response!

This is so funny because I feel just like the robot!

That makes perfect sense.

Thanks.

More useful information - thank you.

Thank you very much - that's exactly what I wanted to hear!

🙂