Linked Tables

XACT_ABORT “OFF” using NAV linked views on linked servers

XACT_ABORT “OFF” using NAV linked views on linked servers I describe this scenario because it’s interesting: NAV with linked views based on linked servers (distributed views). In my scenario i can’t change SQL Server Default XACT_ABORT option, we have two differents configurations for both SQL Servers involved in linked views. The issue is related to […]

Some SQL date calculation scripts for NAV Linked Tables

Some SQL date calculation scripts for NAV Linked Tables Dato che alcuni utilizzano le viste SQL come tabelle collegate in NAV, riporto alcuni script SQL relativi all’utilizzo delle date; inserendo un campo virtuale in una vista SQL e richiamando una “function” esistente o personalizzata nel campo (es: la uf_DaysDifference sotto indicata) è possibile creare delle viste […]

Scroll to top
%d bloggers like this: