Spot on Jeff... I never think to check the profile before replying...

Seeing something like "gemini support team" in the profile then seeing a question posted that doesn't seem to make...

My opinion - I would NOT have modified any upgrade related scripts or any scripts created and provided by Microsoft.

I would follow the same advice that I gave originally:

I would...

My opinion - that is hard to say on a forum post as we have no access to your data or your data structures.  My question to you would be...

I don't think there is enough to go on based on what you wrote.  Plus, what you wrote does not look like TSQL; it looks more like .NET.

So, if you...

My opinion - before making a linked server, find your bottleneck.  If the bottleneck is the network, the linked server is not going to make things any faster.  It will...

Without knowing your setup (hardware side), I would say get a faster network connection.  Transferring 80 GB in 15 hours is just over 5 GB per hour, which is 0.08...

My opinion, I wouldn't be modifying the SSIS package to enable and disable portions of it as things complete (success or failure).  I would have multiple SSIS packages to handle...

I am really confused about what you are asking.... in your expected output, you have 4 columns, yet in your final SELECT you have 6.  So right away, I can...

First thing I notice is that your code for a new user is not using AD.  You'd want a "FROM WINDOWS" not "WITH PASSWORD" for using AD.

Next, if I am...

Since the SELECT takes 11 minutes like the UPDATE, it sounds to me like the data lookup process is what is so slow.  I would look at your execution plan...

aaradhya - I think the app is DOA.  Looking at the link, they have had 10 downloads and it hasn't been updated since December 2020 and personally, I think the...

Pretty sure it depends on your data. I recommend posting some sample data, some DDL, and your expected results so we have something to go on and test.

My thoughts, if it isn't the software firewall, do you have a hardware firewall that your IT team needs to configure?

Alternately, it could be a routing problem.  Depending on your...

Might not hurt to check firewall settings.  Could be that something was recently set up (intentional such as something to improve security, accidental such as a GPO that should have...

To add to what Michael is saying, if you DO get results BUT the results are "NULL" (the literal NULL, not a string), then your variable will also come back...