Understanding the OptimizeForTextSearch Property in Business Central

 Are you curious about the OptimizeForTextSearch field property in Business Central? In my latest YouTube video, I break down:

🔍 How to enable or disable the OptimizeForTextSearch property
🔍 What happens behind the scenes in SQL Server when you modify it
🔍 An interesting open question—what if we change the Boolean value directly in SQL?

This is a must-watch for Business Central developers and anyone working with Dynamics 365 and SQL Server.

🎥 Watch the full video here: Youtube Video

💡 Let’s discuss—what are your thoughts on modifying this property directly in SQL? Drop your insights in the comments of the video!

#BusinessCentral #Dynamics365 #SQL #MicrosoftDynamics365BusinessCentral

Comments

Post a Comment

Popular posts from this blog

STX File Issue - Errors in the text conversion Dynamics NAV 2017

STX File Issue Error -  There are errors in the text conversion because text no. 1880-4 does not exist in the .stx file. Internal error: 47-1 Places where you can get this error -  1) While opening the database in navision. 2) When you try to import the objects in navision. Resolution - The CU17 version of NAV 2017 contains new text constants in development environment. Therefore after installation we need to replace 2 files in NAV installation folder. - path: C:\Program Files (x86)\Microsoft Dynamics NAV\100\RoleTailored Client\ENU - files: fin.etx, fin.stx (in attachment). These files have to be replaced in every installation (on each machine that development environment is running). The files in attachment are only for English language version. If you are using different language, you need to find the specific files for this language (usually in installation folder). You can download the Stx files from here -  Stx Files Feel free to ...
Read more

Unable to Remove Actions from Page/Double Actions on Page

Image
                     We may come across the scenario where we see multiple actions on the page, but some of them are not       working. As an example, we take the following object. Object Type - Page Object Id - 44 Object Name - Sales Credit Memo I Removed all the actions, but still below shown buttons are available and we cannot remove them. Also some of the buttons are giving the error. Solution : - Go to following path – Departments/Administration/IT Administration/Data Deletion/Configuration and Personalization       Go to both the pages. i)     Departments/Administration/IT Administration/Data Deletion/Configuration and Personalization/Delete Profile Configuration ii)     Filter Page Id  iii)   Delete all the entries. Do the same steps for ...
Read more

Powershell in Navision

Image
'll Try to keep things as easy as possible Powershell is a scripting tool, we often see people using following window - Don't use this window, instead use Powershell ISE - Above shown window is more of an IDE for using Powershell, it helps you to use Powershell commands but in an easier way. How to start this? Search for Powershell ISE and choose Run as an administrator - Write the following commands -   Set-ExecutionPolicy Unrestricted  Import-Module "${env:ProgramFiles(x86)}\Microsoft Dynamics NAV\100\RoleTailored Client\Microsoft.Dynamics.Nav.Model.Tools.psd1" -WarningAction SilentlyContinue | out-null Import-Module "$env:ProgramFiles\Microsoft Dynamics NAV\100\Service\NavAdminTool.ps1" -WarningAction SilentlyContinue | Out-Null Import-Module "${env:ProgramFiles(x86)}\Microsoft Dynamics NAV\100\RoleTailored Client\Microsoft.Dynamics.Nav.Apps.Tools.psd1" -WarningAction SilentlyContinue | Out-N...
Read more