What is your question?

After restoring your 2019 backup, you could try running this tool to get the rest of your data moved back:

https://www.devart.com/dbforge/sql/datacompare/

This is not a recommendation, just a possibility. I have...

You can get SSMS to do all of the table-by-table scripting for you, no need for any dread!

https://stackoverflow.com/questions/77508309/how-to-process-full-tables-in-tabular-ssas-cube-using-xmla-file

Linked Server is the specific term you are looking for, I think. Take a look at this link, for example:

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver16

The error relates to memory (ie, RAM) not disk space. If you Google your error, you will see that people have come up with various ways of addressing it (get...

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