Once you go to SQL2019, the minimum database level is 100 !

That may break some stuff if you were to migrate the db and have your app use it on...

Ref Upgrade SQL Server to SQL Server

No we only have named instances on our SQL2005 clusters.

ClusteredSQLServerName\InstanceName is being used to connect with.

Connections which provide the correct port number workt fine

( ClusteredSQLServerName, portno OR ClusteredSQLServerName\InstanceName,portno )

It must be a SQL2005 issue.

All newer Clustered SQL Server instances work are getting connected to without an issue.

It returns the sql server full instance name allright.

local firewall active?

Why is this left join used in your "WHERE NOT EXISTS " parts?

            ...

Why is this left join used in your "WHERE NOT EXISTS " parts?

              ...

indeed. Good point.

Keep in mind, your LOG file(s) may not shrink at first attempt !!!

ref Shrink a log file

can you post your indexes create statement ?

Check out TSQL Restore Database, and you'll find you can to specify new locations for all files making the database

Just add "move .." for the location of the concerned...

• This reply was modified 2 years, 5 months ago by Johan Bijnens.
• This reply was modified 2 years, 5 months ago by Johan Bijnens.

have a look at "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

There should indeed be performance related advantages when using #temp objects.

According to your use case, an index on a #temp object may indeed help out.

performance  - performance - performance -...

What I "love" about these scrum sprint agile and the newer cicd developments is that most managers think it will speed up their sloppy work.

They still don't have a clue...