June 2009 - Posts

How to manage NAV DBCS data using C#
16 June 09 07:26 AM | dtacconi | 0 Comments   

  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 Read More...

Filed under: .net

What do SPNs actually do - NAV 2009
15 June 09 01:36 PM | Lohndorf | 0 Comments   

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 Read More...

Filed under: NAV 2009

Setting up NAV 2009 on Three machines
12 June 09 02:38 PM | Lohndorf | 0 Comments   

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 Read More...

Filed under: NAV 2009

SQL Query to show tables, their indexes and index usage
04 June 09 02:11 PM | Lohndorf | 2 Comments   

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 Read More...

Filed under: SQL