I was trying to connect two databases together, one of the databases is the Dynamics NAV Database while the 2nd database was created with a table called Attach Document due large volume of attach documents in work place.
From the Dynamics NAV Database, Where I have a table contains the following fields;
From the 2nd Database, where I have a table contains the following fields
What i want to is that, when I click attach button from a page in Dynamics NAV Database it should open a connection and allow me to attach the document in the 2nd Database.
NAV can have just one Instance per Database, Via SQL you can do!!