stick with the SSIS wizard and avoid a linked server.
 the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...

yes, i store queries like that in a table, and execute them all the time.
there are two simple ways, note i had to escape the single quotes within the...

grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
what you want is to make sure a copy/paste from a grid still...

here is an example, splitting the list of all your tables in your current database, into five columns;

i think you can adapt that to only have four columns,...

the issues is object owner chaining.  cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
you don't want that, you...

if you have the enterprise version, Data Driven subscriptions are an option.
with data driven subscription, you might have a view that has all the info on a per row...

here's a  scripts i actually put into views ie (GoodMail and FailMail) by toggling the WHERE statement; very handy for at a glance status of emails.
so i can review...

I would assume that some other process is toggling all rows back to zero, and not that SQL is not updating after it explicitly said it updated/Completed.

this link describes numbered procedures fairly well; it is a little used capability that is now deprecated.

you can have different versions of the same procedure, or even completely...

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.