Are you able to provide more details about this issue? I know...

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    SomeId INT IDENTITY(1, 1)
   ,SomeText VARCHAR(10)
   ,CONSTRAINT PK_Nonsense
     ...

Is it so difficult for you to ask a question?

Can anyone provide the T-SQL code I need to amend an identity column from INT to BIGINT, please?

I am guessing that...

That message usually appears when you haven't installed

Microsoft.DataTools.IntegrationServices.exe

after installing VS. However, as this worked for you after updating VS, I'm not sure what's going wrong now.

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, 2 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?