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

this generates the sql and potentially kicks off the command:
what would setting the local password length do? isn't it overwritten by the domain password policy anyway? i think that...

note that when it comes to SQL Server administration, not a lot has changed; if you find a class/book/blog on administration in general, from 2012 and later, say, you would...

proc parameters can only assigning values you cannot concat values or use functions int he assignment.
you simply  pre-assemble the value before assigning it.:
USE Alarms

DECLARE...

you are basically trying to avoid locking and blocking, so here is another idea:

you could also consider inserting the desired 10K rows into a new table, amybe in...