original code has been subject to an incorrect replace somehow.

but it should have been easy for you to identify where an alias is missing and which columns refer to it...

you mentioned ETL - depending on the tool (SSIS for example would require this) you may need to open each of those packages and regenerate column definitions.

what/how and IF depends...

best practice is to grant required permissions only, and not to add to local admin.

If the install of the instance is done with the correct type of user, all those...

but main question is why you need a cursor/while loop?

the reason why the code was removed (post deleted really) is because since sometime ago any post that contains 2 URL's gets that treatment. there is no error, just normal...

they are within the catalog for sure as I use it as well.

but I also change the default cleanup settings and server lvl logging

second link - EA from sparks - paid but good.. and does a lot more than that. it is a architect tool.

https://sparxsystems.com/

hum. I had posted 2 links and post was removed.. darn sotware.

first link - it is free (java based) and works well enough - to use with SQL Server a...

agree with Andre .. AI stink - and mention of things that should no longer be used, while supplying some links that really should not be the ones being supplied.

you didn't put the where clause.

if it is indeed saying "where bill_to_address_id  > 0" I would check to see if it is like that to exclude potential negative numbers or...

can you post the full ddl for table ecom.customer_account - including all indexes and FK definitions.

initial though is that you don't have an index on  "ship_to_address_id" and "bill_to_address_id".

SSIS is tricky - specially if executed through the SSIS Catalog (which should be the case... executing from Visual Studio should not be done except during development).

have a look at...

firewall, wrong dns (do a ping on that box to see ip vs what you get on your pc), wrong instance name (is it a named instance? if so "\"...

look at https://www.microsoft.com/en-us/licensing/product-licensing/client-access-license#tab-overview

if it is a small organization and all the users on that organization are going to need access to the SQL Server (directly or indirectly) then buy device...

on top of setting up kerberos delegation - this now needs to be "constrained delegation" - unconstrained will no longer work due to security changes