Hi Readers, In this article we will see how we can directly modify some fields data of Nav / Business Central Tables directly from SQL Server Database. Step-(1) Run SSMS (SQL Server Management Studio) as Administrator and connect it with desired Server Name. Step-(2) Now select the required Database then Right click on Tables >> Filter >> Filter Settings >> and filterout the table using name. For example: Customer. Step-(3) Select the desired table & Right click on it, then choose Edit Top 200 Rows. Data pane designer window will Open as shown below: Step-(4) Now the above screen shows only top 200 Rows, If we want to show all records just Right click on any field of the data designer pane then select Pane >> SQL this will open the query window. Step-(5) Now to show all records just remove Top (200) from Query and Right click on it then click on Execute SQL. Step-(6) This Data Designer window will show all the records available in the table, yo...
A hub of all my NAV/Business Central Codes.