Open Door Technology

Issue Adding an extended stored procedure for Navision SQL Windows Authentication Solution Extended Stored Procedure ------------------------- ...

Issue SQL Server Performance Solution The biggest problem for Navision and SQL Server has been the keys, sumindexes, etc, and SQL Server is pretty &q...

Issue ODT SQL Audit Solution Microsoft SQL Server Hardware and Software Documentation Checklist Hardware Characteristics Performance Counter (minimum...

Issue Click on File>Database>Information>Sessions and scroll through the records.  Navision locks up and user needs to stop the Navision service....

Issue Modern NAV/SQL troubleshooting II Solution Please refer to this post about what I mean with "modern troubleshooting".  This post desc...