SQL query used by navision

Question Status

Verified
Vishwas Kumar asked a question on 12 Oct 2017 4:15 AM

Dear All,

I need to know about which SQL queries mostly used for navision to solved by problem regarding table and pages.

Reply
Zaid Tariq responded on 12 Oct 2017 4:19 AM

Hi,

You mean the common queries used to solve common problems of NAV? Would be great if you can point out a specific problem.

Reply
Vishwas Kumar responded on 12 Oct 2017 4:31 AM

yes , provide all common sql queries name to solve common problem of NAV

Reply
Verified Answer
Zaid Tariq responded on 12 Oct 2017 6:25 AM

Tip:

- 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

Reply
Suggested Answer
Suresh Kulla responded on 12 Oct 2017 9:49 AM

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.

Reply
Vishwas Kumar responded on 12 Oct 2017 11:26 PM

provide, which Sql queries used by professionals to handle the NAV despite of delete.

Reply
Manish Sharma responded on 12 Oct 2017 11:58 PM

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.

Reply
Verified Answer
Zaid Tariq responded on 12 Oct 2017 6:25 AM

Tip:

- 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

Reply
Suggested Answer
Suresh Kulla responded on 12 Oct 2017 9:49 AM

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.

Reply