So it isn't the client then... I am wondering if it could be the mail server.

If it was consistent it would be easier to figure out.   If it showed up...

As you have Outlook, I'm thinking you likely have Exchange as the back end mail server.  Do you have OWA (outlook web access) on the exchange server?  I have a...

My only thought with this if it is a problem on the DATABASE side is something is going goofy with some data type conversions.  Such as converting VARCHAR to NVARCHAR,...

If they know which switch specifically is having the issues (which is likely), it might be a configuration issue.  Especially if you were upgrading things.  Now, I am not a...

The official docs from Microsoft state it uses that one.  See:

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-ver15

And the table towards the end states that SQL Server (default) uses "Microsoft SQL Server Native Client OLE DB Provider". ...

Hopefully fixing the network issues helps resolve the problem.  My expectation is still that it will.

Packet discards can be tricky to diagnose the problem, but it could be caused by...

To me it sounds like permissions were set wrong likely when fixing the orphan users OR when copying the logins and roles over.

If you still have the 2016 instance around,...

This is an easy one - if you pick SQLNCLI for the provier, it will use the SQLNCLI driver.  SQLNCLI is the SQL Server Native Client driver.

My opinion is to give them least permission possible for them to do their job but also that they accept responsibility for permissions that they claim to require.  For example,...

To add to Erland Sommarskog's reply, adding indexes could make things worse too.  Not likely to make things worse in terms of memory pressure, but increased disk I/O, larger databases,...

Without seeing the script, that is a difficult thing to debug.

My guess is it is not hanging connecting to SQL as that should time out, not just sit hung.

First thing...

So I did a quick test of this by running the following:

DECLARE @test NVARCHAR(20) = '2225504600042'
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test phrase!',@test)) AS NVARCHAR(20))
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test...

To add to Jeffrey's response - the client data may have a newline character in it as well.

If SSIS is your only option, then you are going to need either some 3rd party tool that allows for editing the Excel OR you are going to need to...

Just so I understand what you are asking, you want to know if the following will be counted as 7, 30, 60, 90 and 180:

Insert INto #test1...