To access objects in other databases or on linked servers you must comply with the following rules:
-
You must set the LinkedInTransaction table property to No in order to use a view referring to objects outside of the current database. The ability to modify data in these objects is dependent on the data providers that the objects refer to.
-
You must be a member of the db_owner fixed database role in the current database to access objects in other databases or on linked servers.
-
All security permissions for objects in another database or on linked servers must be granted outside Microsoft Dynamics NAV to the appropriate SQL Server logins.
-
If a linked object refers to a view that accesses objects that are stored in another database on the same server, this view must be treated as though it were accessing a linked server.
- MSDN Link
- - http://msdn.microsoft.com/en-us/library/dd355092.aspx