Return
-
Title
Deleting the custom InTrust search within a SQL query -
Description
Deleting the custom InTrust search is impossible within the GUI method due to the application crash.
-
Cause
The odd time when deleting the custom InTrust search is impossible within the GUI method due to the application crash.
Users may consider achieving that with a SQL query by running it directly against the InTrust configuration database. -
Resolution
DISCLAIMER: Make sure to have a full fresh database backup to recover from in case if something goes wrong.
Using your Microsoft SQL Management Studio run the following query against your InTrust database.
- Select the "Intrust_Cfg_DB" database from the drop-down list.
- In the query window, run the following SQL command to delete the specific search:
DELETE FROM [InTrust_Cfg_DB].[dbo].[SearchItem] WHERE [Name]=Your_custom_search_name_here;