How to manage NAV DBCS data using C#

  It is known that NAV CC (Classic Client) does not support natively DBCS (Double-Byte Character Set) and so does the new NAV 2009 RTC (Role Tailored Client). Due to differences in how the CC and RTC check the code page isn’t still possible to enable DBCS in the RTC but this is possible for…

1

What do SPNs actually do – NAV 2009

Three terms keep coming up when setting up NAV 2009 when NAV-server (middle tier) runs on a different machine than SQL Server:   – Delegation / Impersonation  – Kerberos  – SPN Delegation / Impersonation is what it says it is. Kerberos is handled more or less automatically by Windows. But what do SPNs actually do…….


Setting up NAV 2009 on Three machines

Setting up delegation and SPNs for NAV 2009 on three machines (when the NAV Server and SQL Server are on two seperate machines) is described in “Walkthrough: Installing the Three Tiers on Three Computers”. But in addition to this, also be aware of the following: The syntax of SPNs has changed since KB 968189 You…


SQL Query to show tables, their indexes and index usage

The SQL query below shows a list of tables sorted by the largest tables first. For each table, the indexes in the table are shown. For each index it shows when the index was last used. The query is designed to collect various pieces of information in one place, and give an overview to help supporting decisions when doing…