also i use this proc to update the job description of SSRS subscriptiosn to have the report name; makes it a LOT easier to track down.
it uses dynamic SQL...

you could also create a subscription in Standard edition, and use a SQL Agent job to call the subscription job if the criteria is met.

so assume you create...

There's more than one way to do that.
in my case, the convert function would work nicely, if you include the optional code:
SELECT CONVERT(varchar(10),getdate,112) , where you replace getdate()...

wrong toolbox.
click in the upper right corner here to get the SSIS toolbox instead.

LPIM = Lock Pages In memory?

i had no idea that was a permissions headache, but i found an image!

we'd need to see your update and select statements, really.

does your update inner join to another table?
a SELECT might return more rows, because the other table has...

great, now go back to your queries for all mail and the query i posted for failed mail;
do you see those messages as sent or failed?
did they...

find your name in the upper right corner and click it.
basically your profile page then has three links down at the bottom of your picture...
Topics = Original...

the code generated the command to run. I also pasted it in my post for convenience; it's not as familiar looking  as a regular SELECT statement, but it will try...

notice the item with 40 rows?
that's the one that's stuck.

run teh "ClearQueueCommand" that was in the results:
WHILE EXISTS(SELECT
     'ExternalMailQueue' AS ServiceBrokerQueueName,
     *
     FROM

didn't realize you were running 2005, i should have read deeper. I don't have that version to test against.
comment out that column name, adjust the query a bit till...

design view caches data when it's run the first time, and uses that for design purposes. it does not run the query every time.

http://stackoverflow.com/questions/338009/ssrs-different-results-in-data-tab-and-preview-tab

if you search...

I'm assuming you know that shrinking is a bad thing, etc etc.

your command is almost right, just need to tweak it if you want to assign it to...

ok i found my diagnostics scripts.
run these scripts in the msdb database.

--confirm is_broker_enabled = 1
SELECT DB_NAME([database_id]) AS DatabaseName,
   [database_id] ,
is_broker_enabled ,

Ok ive seen that kind of situation before. You can try the sp_mail_stop and sp_mail_start to fix the service broker, but in the past ive had to completely stop both...