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

How to Check the Business Central Version of the SQL Database

May 9, 2025 by Vidura Dananjaya
How to Check the Business Central Version of the SQL Database - Navuser

Knowing the exact version of your Business Central instance and its underlying SQL database is essential for troubleshooting, upgrades, and ensuring compatibility with extensions or integrations. Use the following query … Read more

Categories D365 Business Central, Development Tutorials Tags SQL Leave a comment

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 Check the Business Central Version of the SQL Database
  • How to Retrieve Server Settings of BC On-premise Client – AL (Read XML File)
  • How to Send Email with Attachments – Simple AL Program in BC
  • How to Create a Custom REST API in Business Central Cloud?
  • C# Program to Call Web Services with OAuth 2.0 Authentication in BC

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
Click to Copy