Try:

GRANT CONTROL ON SERVICE ::ErrorLoggerReceiverService TO SELF

If it works I'll explain why.

It looks like a lot...but if you just copy and paste the T-SQL in order of the blocks that I posted and run each block by itself, you'll see first...

Sorry...LAST post about this...

You will want to apply SP2a to your SQL 2005 boxes...because there's a bug in the service broker.  If you monitor connections with MOM or another admin...

Forgot to mention the reason the message_body is stored as varbinary in the table...it's because you cannot send XML via a linked server transaction.  so if you're not using a...

It depends on what you want to do with the alert.  If you're auditing for information purposes then Event Notifications are best suited for this purpose.

If you want to say,...

If you downloaded SP2 before March 5th 2007, then you need to download the hotfix for SP2 to fix the issue with maintenance plans.

They released SP2a to address your problem.

Oooo...Nice!!  That may be exactly what I'm looking for!

I did however figure out how to clone the database, data and schema exactly as it is in one environment into another...