Browse Site by Tags: sql server, navision

Showing related tags and posts across the entire site.
  • No data returned from SELECT when a field contains an ampersand? (SQL/ODBC query)

    Hello, I upgraded to the Microsoft Dynamics NAV ODBC Driver v6.0.32964.00 and got the following strange behaviour. Lets say I want to select an entry from a table. If I use something like this and the entry with the name 'Meier & Sohn' exists SELECT Nr_,Name FROM Kreditor WHERE Gesperrt=0...
    Posted to Microsoft Dynamics NAV / Navision Integration Forum by Th Kn on 2012-10-2
    Filed under: SQL Server, navision, Dynamics NAV, ODBC, Development, Excel, Nav 2009, SQL, Select statement, ampersand, No data, Upgrade, Query, Lotus Notes, NAV Server
  • How to forbit direct writting in SQL tables

    Could you advice me how to control writting, modifying, deleting data in Navision tables , directly from SQL ? I mean , I want to know if some users modify data in G/L Entry table directly from SQL. The IT auditors need to verify this and to be sure that the product is safe. (navision version is 5.0SP3...
    Posted to Microsoft Dynamics NAV / Navision Developers Forum by Julia on 2012-9-25
    Filed under: permissions, SQL Server, navision, NAV 5.0 SP1, authentication, Windows Authentication
  • How to link and manage Demo SQL server

    I have installed Navision 2009 R2 and SQL server demo database. then I creat a new SQL database and restore a backup data on it, but I did't synchronize all logins. Now I couldn't login this database. How can I direct to link and manage the Demo SQL server and delete the database that I could't...
    Posted to Microsoft Dynamics NAV / Navision Microsoft SQL Server Forum by chao on 2012-9-12
    Filed under: SQL Server 2005, SQL Server, Backup and restore, NAV 2009, Navision, nav 2009 r2, Navision 2.00
  • Deleting Old Date in Navision from SQL

    Hi All, I got one requirement from my client saying that they dont want to keep data prior to March 31 2011, they want us to delete the data including Item ledger entries and value entries from backend (SQL server). currently they are having 5 FY's data they are having from 2007 to 2012. Actually...
    Posted to Microsoft Dynamics NAV / Navision End User Forum by Ravi on 2012-9-7
    Filed under: Navision, SQL Server, Item Ledger Entry
Page 5 of 217 (4340 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »