This error always happens when you create a job for an SSIS package using a remote session of SSMS.  The error is actually being thrown by SSMS, as SSMS can...

I just used the declare block to set up the test values.  You can probably substitute your table where I have
values (@sample1),(@sample2),(@sample3))as dat(sample)

The VALUES...

I have to say, CTE's make this sort of thing  a lot easier.  I am sure there is a better way, but how does this fit for now:

Typical installations are for Report Services to be installed on a standalone server.  These days that is usually a Virtual Machine on a cluster, so you get some high availability...

The ability to run the commands in the procedure gets a little tricky.  Things like TRUNCATE TABLE, and other DDL statements require special permissions at least on a schema level.

Check to make sure the user is running the procedure from the correct database context ( I have seen a number of people default to Master, and not find things...

Can you set a trap on the other side of the linked server?  It is not nearly as effective, but it will give you every time the linked server is...

Role memberships are easy enough


select u.name, r.name
from sys.server_principals u join
 sys.database_role_members rm on u.principal_id = rm.member_principal_id join
 sys.database_principals r on rm.role_principal_id = r.principal_id

Have you tried anything like RunAs?  RunAs is a commandline tool that allows you to run a process as a different user.  I am not sure if you would be...

I would start with the size of the database, and the expected growth rate (size now, size in one year, or monthly growth)

How critical the application is may...

I am going to guess that you have the SSIS service running as Local System, or some other such account.  You can try to switch that for a service account...

This should work:

declare @dt date = '2018-05-10'
select dateadd (day, (9 - datepart(dw, eomonth(@dt, -2)))%7, eomonth(@dt, -2))

Tested on a small sample,.

You will find that the service pack will take nodes out of the potential owners list in the cluster.  If you apply the service pack to the active node, but...

You are right, using the connection pool is the better way to go, especially if you ever have two people hit the website at the same time.

There are ...

An Always On group is composed of several instances that don't directly share any resources.  I think you would be able to have more than 32,767 connections.  If you have...