I wanted to copy the contents of a table of links from one database to another. Both databases are hosted on the cloud-based hosting platform where I host all my sites; they are the backends of DNN instances. Problem is, while I can access my databases from my local machine using MS SQL Server Management Studio (SMS), and I can connect to each database concurrently, I could not find any way to use standard SQL commands to copy the content of a table in one database to an equivalent table in another; it came up with permissions problems no matter what I tried. Here is my solution; there are probably other solutions (e.g. export to CSV, import CSV), and some may be better, but this is how I did it!