there is a limitation imposed - even when doing a create db (and possibly a restore)

Program files and data files cannot be installed in the following situations:

March 8, 2019 at 1:23 pm

#2023980

My memory may be incorrect, but if not mistaken for double hop you do need to have a AD account - GMSA or MSA would be the best as no...

One possibility - depends on how frequent updates/inserts/delets are done on those 2 tables.
Also assumes you have enough space available to hold an extra copy of the tables.

if you are already coding in C# then look at using the available .net to process csv files - after that its easier to deal with the transformation of dates...

your best option is not to use passwords at all.
change all your accounts to be MSA/GMSA accounts - GMSA more versatile as they can be used in more than...

That is a common "error" for must users of Power BI.
Although it asks you initially to sign on, you can close that window as you do not need to...

I think there may be more to this than just a simple insert.
Would it be possible to post here a actual explain plan of that insert (and if this...

yes - but why would you do it if there are better and easier ways to do it?
you can study the openxml model, and create the same...

adding to this . you do not even need to have a PK/FK and you can still join them.

Although FK with indexes will help in some cases from...

you may not be able to see them on ssms - but you can still execute them on the remote server.

you are obviously out of your league. I do advise you to ask for help from another DBA - or at least ask on the forums here before attempting to...

one other possible issue - if the instances were running under his ID, any backup location may also require permissions to be changed. 
This both for doing backups and to...

you are most likely missing the ACE driver on your server.
you can check these if you have sysadmin access to your instance executing exec sp_MSset_oledb_prop
the output will list...