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

Ed generated the string you have to execute.

in his example the last line is the command, it was up to you to execute it
SELECT @strSQL;

you missed the point about entity framework.
the EF DBContext probably has fifty tables or more inside.

It's absolutely possible/probable, that because the context is using a big transaction...

the last lines of the error message tells you where in the code it failed, right?
I'd guess that EF/Linq is adding a bunch of tables to your context that...

also, the attachment has to be accessible to the SERVER; so if the file is on the C: drive of your laptop, and the server is a different machine than...

I've done something like thisrequest, but via powershell; you have a lot more versatility there than pinging stuff via xp_cmdshell
regardless of where you do it, the logic is basically...