Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I need to know about which SQL queries mostly used for navision to solved by problem regarding table and pages.
You mean the common queries used to solve common problems of NAV? Would be great if you can point out a specific problem.
yes , provide all common sql queries name to solve common problem of NAV
- To delete the partner range table you can delete them from the dbo.object table
- To remove all the permissions from a NAV database you can use these commands:
delete from [dbo].[User]delete from [dbo].[Access Control]delete from [dbo].[User Property]delete from [dbo].[Page Data Personalization]delete from [dbo].[User Default Style Sheet]delete from [dbo].[User Metadata]delete from [dbo].[User Personalization]DELETE FROM [dbo].[Windows Login]DELETE FROM [dbo].[Windows Access Control]Will share more with you if found. Thanks
What problems are you referring ? Give some examples ? and why do you need SQL Queries ? Mostly all of the issues need to be solved by making changes in NAV but not running SQL queries.
provide, which Sql queries used by professionals to handle the NAV despite of delete.
SQL is not the common problem solver for NAV. It is the background which stores data, for some specific issues you need to go to SQL.