All I need to do is copy 1 remote table from a backup database, to another database on the same sql server. Table has to include the data from the backup.
Everything I have tried keeps trying to copy every table, with all data. Simply just need a copy and paste like situation. There are no triggers, indexs etc, just the table structure, the keys, and data.