Browse Site by Tags - Dynamics User Group

Inserting Views

Will the DB performance be affected by inserted views? And how about data-manipulation? Will the MS SQL Server (2005) automatically adjust/update the VSIFTs if I insert data manually through a sql-queries? Somebody told me to use the C/ODBC-driver instead but if I got it right it's just for the native...

Posted to NAV / Navision - Microsoft SQL Server by TUNIX on 10-30-2008

Navision SQL Roles

Hi, I'm having a problem where a User which is granted SUPER roles in Navision gets an error when doing a transaction. The following SQL Server error(s) occured while accessing hte PW Inventory - Lot table: 1088, "42000", [Microsoft][ODBC Sql Server Driver][Sql Server]Cannot find the object...

Posted to NAV / Navision - Microsoft SQL Server by pwellar on 10-14-2008

Installing Microsoft FRx for Navision

I am trying to install Microsoft FRx for Navision. During the install, I get the following error: ErrorNumber: 0x80131904 Description: The specified DTS Package ('Name = 'FRL_ACCT_CODE'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist. Setup will now terminate. Has...

Posted to NAV / Navision - Technical Forum by dmauldin on 10-14-2008

Super user cannot access Object

We are using NAV 5.01 and there are number objects that cannot be accessed under our Developer License. All of them report an error such as "You do not have permission to read the '[table name]' Table.' or "You do not have permission to read the '[form name]' Form'....

Posted to NAV / Navision - Developers Forum by DavidWAllen on 09-12-2008

Hardware Guide for Dynamics NAV 4.0 - White Paper version 4.0

Microsoft Dynamics™ NAV 4.0 Hardware Guide for Dynamics - NAV White Paper Version 4 (August, 2007) Table of Contents Acknowledgements Legal Notice Purpose, Terms & Conditions Microsoft Dynamics™ NAV Environment Overview Microsoft Dynamics™ NAV Database Server Microsoft Dynamics™ NAV option for Microsoft...

Posted to NAV - Documentation and whitepapers by Erik P. Ernst on 10-15-2007
Filed under: NAV 4.0, SQL Server 2005, Hardware, performance, SQL Server 2000, Storage, Terminal Services, Remote Clients

NAV 5.00: Installation & System Management: SQL Server Option

INSTALLATION & SYSTEM MANAGEMENT: SQL SERVER OPTION FOR THE C/SIDE CLIENT This book is a manual for the SQL Server Option for Microsoft Dynamics™ NAV. This program is designed to run on SQL Server 2005. This book is part of a comprehensive set of documentation and Help materials for the Dynamics...

Posted to NAV - Documentation and whitepapers by Erik P. Ernst on 03-31-2007
Filed under: NAV 5.0, SQL Server Option, C/Side, Installation, SQL Server 2005, System Management

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 9.0

SQL Server 2005 Report Packs Brief Description These free report packs will simplify your report tasks, improve your business visibility and speed your decision making SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 9.0 Download this set of eight predefined reports that work with Fabrikam...

Posted to GP - Official Files by Erik P. Ernst on 03-21-2007
Filed under: Report Packs, SQL Server 2005, Reporting Services, GP 9.0

SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 8.0

SQL Server 2005 Report Packs Brief Description These free report packs will simplify your report tasks, improve your business visibility and speed your decision making SQL Server 2005 Report Pack for Microsoft Dynamics Great Plains 8.0 Download this set of eight predefined reports that work with Fabrikam...

Posted to GP - Official Files by Erik P. Ernst on 03-21-2007
Filed under: Report Packs, SQL Server 2005, Reporting Services, GP 8.0