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

I didn't have your real table structure, but this is a best guess on if you HAVE to have a static table
CREATE PROCEDURE [dbo].[UpdatePayout]
@accountID uniqueidentifier
AS

my first reaction is thinking outside the corner you are painting yourself in.
a balance like that should be calculated on demand, as a query or as a view, so...

if you are only removing repeating header, you might consider using a  conditional split that tests the string;
then the conditional split can redirect the headers, or maybe do nothing...

the FK's point to the object_id of that lookup table,and not the name. you can see that is some of the sys views, like select * from sys.foreign_keys; the name is...

there are a number of "StripNonNumeric" functions here on SSC scripts section:
http://www.sqlservercentral.com/search/?q=StripNonNumeric

I would strongly recommend either of the inline table value function that Sean Lange or Alan...

Like Sue suggested, i use Powershell, as a scheduled job step to remove any abf files older than x number of days.
not sure how you are backing up, in...

is there any chance that when you installed Developer2016, you didn't install Integration Services? this screenshot shows the checkbox unchecked; i'd suspect that that might be issue. SSDT is the...