i've been using a modified version of this script sp_help_revlogin_roles, which scripts logins and some server roles for you for an easier migration:

https://www.itprotoday.com/strategy/cloning-security-objects-between-servers

sp_send_dbmail is asynchronous. the whole process is already a service broker.
it returns success and an mail_od immediately without actually sending anything, and puts it in a queue.

the...

not sure if this helps.
Fore security reasons, i never log in as my elevated account, but as a regular account,and spawn applications with the privileged account as needed. via...

Here's my first suggestion:

grab a copy of Adam Mechanic's sp_whoisactive and put it in the master database:
http://whoisactive.com/downloads/

running a command like this manually will give...

For Production, NetApp SNAPs cannot do an individual databases point in time restore, can it?
if they can demo you can rollback to a specific point in time, for one...

they need to bump up their skillset, and this is your opportunity to help them.
do not allow SQL connections. period. eventually that password gets passed around and is insecure.

i would resolve it forever.
granting execute to the role without limitations like the script did, grants that right to all objects current and created in the future, so you...

in my case, in all my databases, i create a custom role, and grant some developer group access to that role:
IF NOT EXISTS(SELECT 1 FROM sys.database_principals dp...

it sounds like the procedure is being dropped and recreated. that would lose all permissions in the way you describe, but appear as if the permission was revoked, instead of...

as someone mentioned, it is a big topic, with a little bit art and a little bit experience to tune the queries on a server.

In my opinion, this...

I didn't see the real schema of the table, but here is my advice:
while you cannot change the schema, you can add new tables to keep track of what...

there are a number of built in functions you can use to get error and other information.
parent procedure (the name of the procedure calling a procedure, for example) or...

depending on the data types being passed in the table definition itself, sometimes no more than two versions difference allowed for replication between the publisher and the subscriber.

SQL...

the using definition is your friend here.
using that will automatically destroy your object for you once they go out of scope:
change those two lines for your object to...

I use a version of the query below every M-F:
it returns all jobs who's LAST status is failed.
that means jobs that execute every x minutes,and experienced a hiccup,...