Skip to content
NAVUSER
  • Home
  • Development Tutorials
    • Dynamics Navision
    • D365 Business Central
    • Azure
  • Functional Tutorials
    • D365 Business Central
  • Videos
    • Dynamics 365 Business Central Technical Video Tutorials

SQL

SQL Query to Delete All User Data for RTC Versions of Dynamics NAV

March 11, 2022July 8, 2021 by Vidura Dananjaya
SQL Query to Delete All User Data for RTC Versions of Dynamics NAV

After deleting all user data in the database, the Dynamics NAV client will be adding the running Windows user automatically with the first login. You can execute the following SQL … Read more

Categories Development Tutorials, Dynamics Navision Tags Delete User Dynamics NAV, Dynamics NAV, Dynamics NAV Developments, SQL Leave a comment

How to Resolve SQL Server Data Type Error on Dynamics NAV

January 30, 2023July 7, 2021 by Vidura Dananjaya
How to Resolve SQL Server Data Type Error on Dynamics NAV Version List VARCHAR(80)

When you tried to open the Dynamics NAV database with a different build, the SQL data type (VARCHAR(248)) of the Version List field can be change and conflict. With this … Read more

Categories Development Tutorials, Dynamics Navision Tags Dynamics NAV, Dynamics NAV Developments, SQL, SQL Server Data Type Error Leave a comment

Add Windows User With Permissions Using SQL Query of Dynamics NAV

January 30, 2023July 5, 2021 by Vidura Dananjaya
Add Windows User With Permissions Using SQL Query of Dynamics NAV

Use the following SQL query to add a Windows user with the permission set for Microsoft Dynamics Navision 2013 R2 or 2015. Before executing the query in the relevant SQL … Read more

Categories Development Tutorials, Dynamics Navision Tags Add Windows User, Dynamics NAV, Dynamics NAV Developments, SQL Leave a comment

Recent Posts

  • How to Call a Rest API GET Request in AL (Making a real-time currency exchange rates viewer)
  • Interfaces in AL Programming – Same as OOP Languages
  • How to Debug Business Central Production Environment by Snapshot Debugging Method
  • Function for Split Text With Maximum Characters Without Damaging Words – AL / C/AL
  • How to Setup Email and Assign Email Scenarios in Dynamics 365 Business Central

Categories

  • Azure
  • D365 Business Central
  • D365 Business Central
  • Development Tutorials
  • Dynamics Navision
  • Functional Tutorials
Copyright © 2021 All rights reserved - Disclaimer | Privacy Policy | Terms of Service | Contact