Hi Guys,
Am trying to export tables from one database to another using microsoft SQL Server 2008 and Navision SQL Server Option. However, I am getting read-only error on the destination database. The two databases are exactly the same. My aim is to copy data from one to another. Any ideas how we can achieve this.
Please help!!!
0
Comments
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Check if login or user used to connect to destination database has sufficient rights to this database. Check this as SQL level - as under normal circumstances NAV users are granted only public level access to NAV database, and NAV handles security using application roles permissions and not logged user permissions.
Slawek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03