I've had a quick look in the documentation and can't see anything that suggests you cannot create a linked server in SQL Server Express. Have you tried? What happened when...

As the error message suggests, the JSON is invalid. You have three open braces and only two closing braces.

• This reply was modified 1 year, 7 months ago by Phil Parkin.

Your temp table struct is unpleasantly denormalised – perhaps by design, but I suggest you have a rethink about it, because this is very easily done with normalised data, as...

It is possible that your e-mail provider has started enforcing TLS 1.2 for e-mail traffic and that this has caused the issue.

Scott's advice is solid. I suggest you compare execution times between the solutions offered and then you'll see why.

Is this something which used to work and has started failing, or has it never worked?

What do you want to see if the values are different? Which value takes precedence?

--Deleted

• This reply was modified 1 year, 7 months ago by Phil Parkin.

SSIS can run compiled code through the use of an Execute Process task.

Thanks for the response..

how do we check what you recommended ?

https://www.sqlservercentral.com/blogs/quick-tip-wmi-alerts-and-sql-server-agent-permissions..

Let me check and get back...

But the query captures data from 100+servers...so how does this work...check on all servers...

Assuming the package is deployed to SSISDB, it is possible to execute it by calling a stored procedure.

Stored procedures can be called from a SQLCMD command line and parameters can...

The tool should allow both scheduling and manual execution of jobs.

I'd prefer an attractive interface where we configure jobs, set up who can execute those jobs and perform the execution...

Might be a bit to powerful for what you need but check out dSeries workload automation from Broadcom, used that in the past for this type of centralised job...

Thanks for responding. I'm hoping to find something a bit prettier than SQL Agent, and ideally a product which is independent of SQL Server, as it may be used for...

Note to self: remember to rent a Lambo one day.