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

take a look at the last errors, you might be getting a very specific error, like relaying denied,  failed logins, etc.

by default, database mail will retry once (within...

i think this will do it.
i'm using datemath to round the dates down to midnight of each date, and grouping by that

select DATEADD(dd, DATEDIFF(dd,0,Invoice_Exceptions.DateTime), 0)...

if you've installed SQL locally, there are aliases you can use, but you can also see what is installed and running.
if you go to start>>Run>>services.msc
it will open your...

could it be that the construction of the query, where it says COLUMNNAME IN(singlevalue) causes a range scan, where if it was COLUMNNAME = singlevalue , it would be an...

i had quite a bit of luck finding some resources here:
https://www.google.com/search?q=hardening+sql+server&rlz=1C1CHBF_enUS707US707&oq=hardening+sql+server&aqs=chrome..69i57j69i60.3839j0j7&sourceid=chrome&ie=UTF-8

this one has a decent checklist of things to do, but not the scripts and details:

if you convert time directly to datetime, itends up being 1900 anyway, so just do a direct conversion.
CONVERT(datetime,convert(time,durationvalue)) As DurationTime2 or directly like convert(datetime,durationvalue) AS DurationTime3
WITH ...

my first guess, but i converted the copy/paste to consumable data:

;WITH MySampleData([OrderNumber],[rtype],[jobnumber])
AS
(
SELECT '8316','J','1' UNION ALL
SELECT '8316','L','2' UNION ALL
SELECT '8316','K','3' UNION ALL