Thanks Ant. That's almost exactly what our AD admin said.  The GPO's are the same

Thanks for the reply Brian

It's definitely a driver issue.

If I create a DSN from the application box using the SQL server driver and test it I get

Microsoft...

Thanks Anthony.

Logged this on GitHub https://github.com/sqlcollaborative/dbatools/discussions/7012

BTW I tried confirm:$false and it made no difference

Just I thought.....

I kept copies of all the system and user databases,

uninstalled the core version of SQL,

reinstalled the CAL version of SQL (same version and edition)

Shutdown SQL

Copied back all the...

Bump 🙂

That's what I thought Eddie.

Thanks for the reply

Ok I slightly misunderstood you, I thought there was a separate compatibility level setting in the SSIS packages.

All the imported databases are compatibility level 120. MSDB is 130, I did...

Hi luismarinaray

SSIS is not my string suit.

Could you point me to some documentation.

Cheers

Alex

Hi

Thank you both for the replies.

I'd already read the stackoverflow and it's full of useful information but I can't see how it moves me forward. The 2016 server is SP2...

Hi

could you explain how you worked out that

CREATE INDEX IX_Table1_1 ON Table1(Column2, DateTime)

would be a useful index

Thanks

Alex

Hi Jonathon

Awesome....

This index really seemed to nail it.

CREATE INDEX IX_Table1_1 ON Table1(Column2, DateTime)

Thanks 🙂

Alex

Hi Erland

Thanks for the reply....

The truth is it's not my code, I'm not sure what it's trying to achieve, I'd just like to try and make it more performant because...

Looks like this may be an application\performance issue at the DR site.

Thanks for your interest.

Alex

So far, no error at all.

I just updated a single record. Everything looked ok, but when I restarted SSMS and queried the table the update wasn;t there.

I'm just going to...

Hi Steve

Thanks for the reply,

I'm just doing some initial investigations, I'll post up some results in half an hour or so. This landed on my desk after being on leave...