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

any chance you edited the Script task template itself?
i got the same error, but I knew it was me.
i edited the template for Visual Studios C# Script task,...

the data can have none to many rows in sys.logins. the statement is just building the commands dynamically, really.

remember you can run multiple commands, and the recommendation is...