Skip to main content

Trace Flag is no more Required


You may remember that customers who were running NAV 5.0 and NAV 2009 with SQL Server option were required to enable the Trace Flag 4616 in the SQL server database. However, this is no longer required with the latest NAV 2009 SP1 version, as it uses “VIEW SERVER STATE” permissions to enable visibility to the required connection information for each user. Therefore, now it is recommended that Trace Flag to be disabled after upgrading it 2009 SP1. If you are going for new installation, of course this is not required at all.
In most cases, we enabled the Trace Flag by adding it to the startup parameters by opening the "Configuration Tools" folder of the "SQL Server Configuration Manager". However, you can disable it now by following the below steps;

1. Go to Start-> Run and select the "Microsoft SQL Server 2005/2008" program group, select the "Configuration Tools" of the "SQL Server Configuration Manager" tool.
2. Double-click on the SQL Server service.
3. Select the "Advanced" tab
4. In the list of values double-click on the one called "Startup Parameters"
5. In the list of values for this parameter (mostly at the end), remove the following: ';-T4616'
6. Click OK to save the change.
7. Restart the SQL Server service


Note:
In certain instances, you may have done this by using the DBCC TRACEON command. If that is the case, you could also do this by SQL Server Query Window.

Comments

Post a Comment

Popular posts from this blog

Upgrade from NAV 5 to NAV 2009 SP1 – A Quick Guide

Regardless of the version from which you are trying to do the upgrade, the whole process can be divided into two main phases as Object Upgrade and the Data Upgrade. Let’s first look at the Object Upgrade. In Object Upgrade, you have to identify all the customizations done in the current live version of the customer database and implement the same in a new 2009 SP1 database. Please remember that there are no short-cuts for this process. This is entirely a manual process, but you can make use of the existing tools such as Developer Toolkit. Using the Developer Toolkit you can compare/merge the original version 5 db and the current customer database wherein you can identify the differences between the two databases and implement the modifications in a new 2009 SP1 fresh database. Once you complete this process, you are through with the phase no 1. Remember that this is the most time consuming phase in an upgrade project. If you make any mistakes then you have to suffer a lot in the subseq...
4 comments
Read more

Navision Employee Portal

Employee Portal provides a Web-based interface that gives employees quick access to mission-critical business information such as invoices, customer data, and some selected reports. Moreover, it real time integrates with the standard Microsoft Dynamics NAV database while collaborating with Microsoft® Windows® SharePoint® Services 3.0 (WSS 3.0) or Microsoft Office SharePoint Server 2007 (MOSS 2007) to provide you a browser based interface. Depending on the volume of transactions and the number of concurrent users, you can setup Employee Portal to run with either WSS or MOSS. However with MOSS, you would get additional support for making further developments. Employee Portal can also be identified as a Web Portal for Sales Persons who travels all over the country. In such instances, salesperson can logging to NAV and start creating Sales Orders or Sales Quotes as required by them. Let’s look at some typical screens available in the default Web pages. Item List /Product List Page This p...
3 comments
Read more

How to run an External Application within Dynamics NAV

Perhaps you may have inquired the possibility of executing an external program within Dynamics NAV due to many reasons such as; 1. To run an external application like Windows Calendar or Skype within NAV 2. To run a Crystal Report using a Icon available in NAV Whatever the reason, concept for making this a reality would be as follows; Initially you may have to find out the directory path where the executable file of the external application is located. For example, let's assume that you are in need of calling the windows Calendar within Payment Journal Screen. You can search the calc.exe file where it is located. Mostly this is available in the windows System32 directory. Therefore the relevant directory path could be defined as 'C:\WINDOWS\system32\calc.exe'. In CAL, you could call the Calendar Control by giving the following command; SHELL('C:\WINDOWS\system32\calc.exe'); This can be achieved by placing an additional command button in the Payment Journal Screen. I...
2 comments
Read more