I have been working for years on a semantic search engine in WPF and in Asp.Net with C# and Sql Server 2022 and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters.

I have encountered the problem that the parameter “contains_search_condition” of the Contains or ContainsTable command is limited to 4000 characters.

Just by searching for the synonyms and inflections of a word, this limit can be exceeded. It is not solved even if the words are entered into a Varchar(max) variable and passed to the parameter.

I can’t use the synonyms system that T-Sql includes for “Full Text” because it is too simple and has multiple errors and shortcomings and I think it was abandoned in 2008 because they never talked about it again.

Several years ago I reported this problem and other important problems that I have found in T-Sql to Microsoft Spain in writing, who reported it to Microsoft USA. They told me that “they were going to work on these problems.”

I have not heard anything again and I need a solution, because I am stuck on this problem.

I cannot write the query text because it says “violation of the code of conduct” and deletes the post.

I have left the SQL code at: https://mega.nz/file/9xxThBDK#dBWn5Tdy0IvtdCd3qtpq9Mk8C-29pO87TogdvAB2zVI

This is a current query:

I have tried to split as Rodger Kong advised me but the problem persists.

​I have been working for years on a semantic search engine in WPF and in Asp.Net with C# and Sql Server 2022 and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters. I have encountered the problem that the parameter “contains_search_condition” of the Contains or ContainsTable command is limited to 4000 characters. Just by searching for the synonyms and inflections of a word, this limit can be exceeded. It is not solved even if the words are entered into a Varchar(max) variable and passed to the parameter. I can’t use the synonyms system that T-Sql includes for “Full Text” because it is too simple and has multiple errors and shortcomings and I think it was abandoned in 2008 because they never talked about it again. Several years ago I reported this problem and other important problems that I have found in T-Sql to Microsoft Spain in writing, who reported it to Microsoft USA. They told me that “they were going to work on these problems.” I have not heard anything again and I need a solution, because I am stuck on this problem. I cannot write the query text because it says “violation of the code of conduct” and deletes the post.I have left the SQL code at: https://mega.nz/file/9xxThBDK#dBWn5Tdy0IvtdCd3qtpq9Mk8C-29pO87TogdvAB2zVI This is a current query:I have tried to split as Rodger Kong advised me but the problem persists.     Read More

​

I have a Network-Attached Storage (NAS) system that is accessible from four computers. When I attempt to access or run batch scripts on one of these computers, I receive an “Open File – Security Warning.” Interestingly, this prompt does not appear on at least two of the other computers. Unfortunately, I cannot confirm whether the same warning occurs on the remaining computer as I do not have access to it at the moment.

The warning message correctly identifies me as an “unknown publisher.” Curiously, Windows does not flag the same script when run from a local drive. I am baffled as to why this particular computer is being overly cautious and prompting this warning, as I believe it is likely due to a misconfiguration on my part. I have attempted to locate and rectify the setting causing this issue, but thus far have not been successful. If you have any insights on what may be causing this discrepancy and how I can address it, I would greatly appreciate your assistance.

​I have a Network-Attached Storage (NAS) system that is accessible from four computers. When I attempt to access or run batch scripts on one of these computers, I receive an “Open File – Security Warning.” Interestingly, this prompt does not appear on at least two of the other computers. Unfortunately, I cannot confirm whether the same warning occurs on the remaining computer as I do not have access to it at the moment. The warning message correctly identifies me as an “unknown publisher.” Curiously, Windows does not flag the same script when run from a local drive. I am baffled as to why this particular computer is being overly cautious and prompting this warning, as I believe it is likely due to a misconfiguration on my part. I have attempted to locate and rectify the setting causing this issue, but thus far have not been successful. If you have any insights on what may be causing this discrepancy and how I can address it, I would greatly appreciate your assistance.  Read More

​

I recently switched to Windows 11 and am accustomed to having the taskbar positioned on the left side of the screen. Is there a way to customize the taskbar layout in Windows 11 to have it aligned to the left?

​I recently switched to Windows 11 and am accustomed to having the taskbar positioned on the left side of the screen. Is there a way to customize the taskbar layout in Windows 11 to have it aligned to the left?  Read More

​

Occasionally, when attempting to pin a new app to the taskbar, the existing pinned shortcuts vanish abruptly, prompting a need to re-pin them. This issue arose multiple times when trying to add the PowerShell 7 terminal to the taskbar. Furthermore, whenever I re-pin the shortcuts, numerical increments are added to the app labels, similar to file copying scenarios where duplicates are labeled with numbers, for instance: Discord (4), Brave (4), PowerShell 7 (x64) (3). I am curious if the pinned shortcuts are duplicated in a designated folder location, resulting in the appended numbering. Is there a way for me to manage, relocate, or create backups of these pinned shortcuts?

​Occasionally, when attempting to pin a new app to the taskbar, the existing pinned shortcuts vanish abruptly, prompting a need to re-pin them. This issue arose multiple times when trying to add the PowerShell 7 terminal to the taskbar. Furthermore, whenever I re-pin the shortcuts, numerical increments are added to the app labels, similar to file copying scenarios where duplicates are labeled with numbers, for instance: Discord (4), Brave (4), PowerShell 7 (x64) (3). I am curious if the pinned shortcuts are duplicated in a designated folder location, resulting in the appended numbering. Is there a way for me to manage, relocate, or create backups of these pinned shortcuts?  Read More

​

I recently encountered an issue where the option to create a new ‘text’ document disappeared from the right-click menu in a folder. I usually use this feature quite often, so it was frustrating to see it missing. Instead, I was presented with a list of Microsoft Office document options and a few others like a bitmap image. 

After investigating further on another computer, I noticed that only a few extra entries were available, such as a text document, Photoshop Elements document, and Visio diagram. However, the crucial ‘text document’ option was missing.

Thankfully, I found a solution by right-clicking on an existing text document, selecting ‘open with’ and then choosing a different app like Notepad. By setting Notepad as the default app and then switching back to Notepad++, I was able to restore the ‘text document (Notepad++)’ option in the right-click menu. This workaround appears to be a common strategy to promote Microsoft options over non-Microsoft ones. Let’s see if the issue persists.

​I recently encountered an issue where the option to create a new ‘text’ document disappeared from the right-click menu in a folder. I usually use this feature quite often, so it was frustrating to see it missing. Instead, I was presented with a list of Microsoft Office document options and a few others like a bitmap image.  After investigating further on another computer, I noticed that only a few extra entries were available, such as a text document, Photoshop Elements document, and Visio diagram. However, the crucial ‘text document’ option was missing. Thankfully, I found a solution by right-clicking on an existing text document, selecting ‘open with’ and then choosing a different app like Notepad. By setting Notepad as the default app and then switching back to Notepad++, I was able to restore the ‘text document (Notepad++)’ option in the right-click menu. This workaround appears to be a common strategy to promote Microsoft options over non-Microsoft ones. Let’s see if the issue persists.  Read More

​

Hi everyone,

Im using Outlook Version 2408

I have a sensitive label Confidencial set to let user assign permissions and the option Do not Forward Enabled

If I remove the label or change it to a lower priority one without encryption. The option Do Not Forward is not automatically removed.

I have to remove it manually from the option Encrypt to fix it.

With the Outlook new version or Web this is not happening, but some user still use these Outlook Desktop version

This will be a problem by the time for users. They might be sending encrypted email messages accidentally or sending encrypted emails with Public sensitivity label. Is there any way to fix it.

Thanks for your help.

​Hi everyone, Im using Outlook Version 2408I have a sensitive label Confidencial set to let user assign permissions and the option Do not Forward EnabledIf I remove the label or change it to a lower priority one without encryption. The option Do Not Forward is not automatically removed. I have to remove it manually from the option Encrypt to fix it.With the Outlook new version or Web this is not happening, but some user still use these Outlook Desktop version This will be a problem by the time for users. They might be sending encrypted email messages accidentally or sending encrypted emails with Public sensitivity label. Is there any way to fix it. Thanks for your help.     Read More

​

Hello Everyone,

I am having trouble finding the Excel Data Analysis Toolpak. Whenever I try to find the add on it is not there, the only add on I can find is the XLMiner Data Analysis Toolpak, which is not the one I am looking for. There is no add on option under the Options tab. I am currently using excel under my school. 

Thank you. 

​Hello Everyone, I am having trouble finding the Excel Data Analysis Toolpak. Whenever I try to find the add on it is not there, the only add on I can find is the XLMiner Data Analysis Toolpak, which is not the one I am looking for. There is no add on option under the Options tab. I am currently using excel under my school.  Thank you.   Read More

​

I am running Outlook 2016 and I can’t find out how to show a ribbon at the top of the screen.

Searching for solutions on here pints me to auto hide or use the ellipsis icon but neither of these are showing, all I can see are restore down, minimise and close.

Can anyone help me please?

​I am running Outlook 2016 and I can’t find out how to show a ribbon at the top of the screen.Searching for solutions on here pints me to auto hide or use the ellipsis icon but neither of these are showing, all I can see are restore down, minimise and close.Can anyone help me please?   Read More

​

Please keep in mind the following information regarding Windows 11’s Fast Startup feature:

Fast Startup is intended to reduce boot times, but it can create problems for some users. After updates or system changes, Fast Startup may re-enable itself even if you have previously turned it off.

The issue lies in the fact that Fast Startup can impede access to Advanced Startup options, including Safe Mode. This can complicate dealing with potential malware infections, driver conflicts, or other system-level problems.

It is uncertain whether this behavior is a bug or intentional, but it poses a significant inconvenience for users who rely on Safe Mode for troubleshooting and maintenance.

Key points to note:

– Fast Startup can turn itself back on, even if you have disabled it previously.

– This can make it challenging to access Advanced Startup options, including Safe Mode.

– Troubleshooting boot issues and potential security threats becomes more difficult.

– Users should be aware of this issue and take steps to address it.

If you have encountered this problem, here are some suggestions:

– Regularly check your power settings to ensure that Fast Startup remains turned off.

– Consider using the registry edit method (with caution!) for a more permanent solution.

– Provide feedback to Microsoft regarding this issue through the Feedback Hub or online forums.

Let’s voice our concerns and advocate for more user-friendly boot options in Windows 11!

Remember, any re-enabling of Fast Startup without your knowledge is a serious and unacceptable issue!

​Please keep in mind the following information regarding Windows 11’s Fast Startup feature: Fast Startup is intended to reduce boot times, but it can create problems for some users. After updates or system changes, Fast Startup may re-enable itself even if you have previously turned it off. The issue lies in the fact that Fast Startup can impede access to Advanced Startup options, including Safe Mode. This can complicate dealing with potential malware infections, driver conflicts, or other system-level problems. It is uncertain whether this behavior is a bug or intentional, but it poses a significant inconvenience for users who rely on Safe Mode for troubleshooting and maintenance. Key points to note: – Fast Startup can turn itself back on, even if you have disabled it previously.- This can make it challenging to access Advanced Startup options, including Safe Mode.- Troubleshooting boot issues and potential security threats becomes more difficult.- Users should be aware of this issue and take steps to address it. If you have encountered this problem, here are some suggestions: – Regularly check your power settings to ensure that Fast Startup remains turned off.- Consider using the registry edit method (with caution!) for a more permanent solution.- Provide feedback to Microsoft regarding this issue through the Feedback Hub or online forums. Let’s voice our concerns and advocate for more user-friendly boot options in Windows 11! Remember, any re-enabling of Fast Startup without your knowledge is a serious and unacceptable issue!  Read More

​

At the moment, enabling Azure Automanage for a new Azure VM or Arc-enabled server results in the following error:

An error occurred while assigning the configuration profile named ‘Azure best practices: Dev / Test’. Error details: The operation was not allowed because the subscription is not in a state to support it. Subscription state: -1

Additionally, attempting to create a custom configuration profile results in the following error:

An error occurred while creating the configuration profile named ‘amcp-prd-arc-infra-01’. Error details: The operation was not allowed because the subscription is not in a state to support it. Subscription state: -1

Has anyone encountered this issue before and found a solution?

​At the moment, enabling Azure Automanage for a new Azure VM or Arc-enabled server results in the following error: An error occurred while assigning the configuration profile named ‘Azure best practices: Dev / Test’. Error details: The operation was not allowed because the subscription is not in a state to support it. Subscription state: -1 Additionally, attempting to create a custom configuration profile results in the following error: An error occurred while creating the configuration profile named ‘amcp-prd-arc-infra-01’. Error details: The operation was not allowed because the subscription is not in a state to support it. Subscription state: -1 Has anyone encountered this issue before and found a solution?  Read More

​