Enabling SSL would encrypt the connection between the source and destination.  One of the main benefits of SSL is that MITM (man in the middle) attacks don't work on them...

I would first determine what you need to do with the data and if this is a long term solution (ie you are going to need to do this import...

I have not run into this, but I have a few thoughts.  First, are you using SSMS 2012 or a newer version?  I know with some things (SSIS comes to...

You make some good points Scott.  I think my approach had been that NOLOCK, like CURSORS, should be avoided except where absolutely necessary.  It was what I had read in...

Scott - I agree that NOLOCK has its purposes, as do all query hints.  Otherwise they wouldn't be in there to begin with.  I was just trying to over-emphasize that...

Do you have any database monitoring tools (such as RedGate SQL Monitor)?  If so, put the alerts in there.

If that isn't an option, I think you are going to need...

To add to what pietlinden said, I think that a DISTINCT and a SUM are going to be your friend in this query.

This is also just my preference, but I...

As a random thought, IF your variables are coming from a 100% safe place OR you restrict the stored procedure so that only DBA's can run it, what if you...

My opinion - each "feature" of SQL that you enable requires knowledge and skills on how to work with it.  For example, if you turn on memory optimized tables, do...

From looking at that, the problem is indicated in the first error - Parameter arrays with data at execution are not supported by the MySQL/MariaDB ODBC driver.

If you have a table with a clustered index that you cannot rebuild or reorganize, I think the ONLY other thing you could do to reduce the fragmentation percentage would...

I'd have a read on this page:

https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-heaps-and-their-fragmentation/#:~:text=In%20SQL%20Server%2C%20heaps%20are%20rightly%20treated%20with,that%20space%20is%20allocated%20and%20forward%20pointers%20used.

But basically, "alter table <tablename> rebuild" will rebuild your heap.

Does that table need to be a heap or would it benefit from an index?

Just to confirm, if you log into the server while the job is running and load up task manager, who does cscript.exe say it is running as?

The reason I ask...

Just my opinion, but do you need ALL of the ERP data?

The reason I ask is if you aren't needing all 130 GB of data, it MAY be faster to...

What is likely happening is sys.tables is getting a lock due to the SELECT * INTO TableName which would create the table AND do a select in a single transaction...