Just an update, last night run is successful, and the duration is normal too.

The two things we changed is to use FQDN instead of server name for the application call...

• This reply was modified 6 years, 2 months ago by sqlfriend.

after we restarted server, last night it runs in the middle of the process of 2000 of 6000 records, it gave the error:

Errors :                {                                System.Data.SqlClient.SqlError: A transport-level error...

Thank you for the analysis.

I don't think we use web browser, it  is not something used by front end, it is a batch service that use a web service runs...

The job is a web service, it is triggered by a command line batch .bat file on the web server, the bat file calls  a web service on the web...

Thank you.

This is not a SSIS package it is a web application/batch service , that runs from web server but it updates the database on a separate database server.

The database...

Thanks, this is ECM Opentext software database server, I did not manage it until today I found the alerts. Asked their team they said some contractors are loading some data...

this is what I got, every 3 hours, but I changed yesterday to every 2 hours. I did not got this alert before, is that possible there...

• This reply was modified 6 years, 3 months ago by sqlfriend.

Thanks for the detailed explanation. That makes a lot of sense. and quite helpful.

Yes, the old server is still running .  I can certainly shut down the  service on  old server after a day or two.But just want to figure out the concept....

Thank you!

Yes, that is exactly what I think too. Maybe my version (CU5) is too new for the upgrade wizard, or it has a bug in CU5.

I installed RTM first,...

Thank you Brian.

Yes, I do install SQL SSIS instance, from the configuration manger I can see SQL server integration services 15.0 is running.

I changed the compatibility level to 150. And...

Thanks!

So the first one :

The password you use when you create the master key is used to open it if you break the hierarchy of allowing the Service Master Key...

Thanks!

So this will be only in join place?

what about comparing statement like:

Where a.firstname <>b.firstname,

Etc.

So this will only affect queries involving tempdb collation?

What about when join other user database (not system ones) with different collations?

Thanks

Also for your statement:

"The other thing you could do is add a password onto the database master key.  That way you can open the master key and add decryption by...