i believe  msdb.dbo.sysmail_allitems will only have a single row per mail_id, along with it's current status (sent/unsent/failed)

when a mail does fail, an entry is created in sysmail_event_log
[code...

i've used WinCD Emulator, which mounts an iso as if it were a drive, and also http://wincdemu.sysprogs.org/

and also
Virtual Clone Drive
https://www.elby.ch/en/products/vcd.html

I like...

there's no race condition that i see.

Luis's test tests that one  table or the other has rows; i thought it was very elegant.
IF EXISTS(SELECT * FROM #temp1)

whoops i was assuming Azure SQL, and not DW, my fault, thank you for the clarification Gail!
I read the request too quickly.

your code for the function [sys].[dm_db_index_physical_stats] is hardcoded to database_id = 5, is that right?
 i prefer to use the db_id and current database context.
object_id('') will resolve to null, just...

the structure of a database and dmv's are all exactly the same, whether Azure or SQL
any script that would generate scripts for indexes or users, or anything like that...

why not have a new DBA job that now  updates any jobs not owned by [sa] to be [sa], and any job steps that are of type SSIS to have...

seems like the right thing to do is simply replace dbo permissions with something that is almost, but not quite the same. that would address the issue, i would think.

awesome. that's the way to code defensively.

did you hard code it to a string 'EXECUTE AS', so 'EXECUTE{CrLf}
AS' would still be allowed?

nevermind...you explicitly said you toggled 32 bit mode....

I've written cleanup procedure that generate the sp_rename command for what i consider the the friendly name., so if the constraint doesn't match my expected name, it generates a command...

is it not true that the only person that can do a procedure featuring  EXECUTE AS  is going to be a sysadmin anyway?
a regular user cannot create a procedure...

DatabaseMail , in a way, is exactly like any other  mail client...office365,ThunderBird, Google Mail, etc. it just uses a connection to a real mail server to forward an email, which...

"not running" doesn't tell us anything.
if you got a specific error, tell us the error.
if you ran the select, was it an empty string?
maybe you have schemas...