Technology

Trace Flag is no more Required

Premanath Kumarage · Author
2 min read
Hands on a laptop keyboard with a candlestick trading chart overlaid

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.

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.

Written by

Premanath Kumarage

Author

All insights →

Start here

Every piece here started as a client problem. Tell us yours.

A working session, not a sales call. Bring the process your current system fights you on, and we will tell you plainly what it would take to fix it.

Newsletter

One email a month. No filler.

Stay ahead with Microsoft Business Applications.
Insights, implementation advice and practical ideas to help your business get more from Microsoft technology.

By subscribing, you acknowledge MicroCloud 360’s Privacy Policy.