Server Error in '/' Application.

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'searchfaqs' because it is not full-text indexed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'searchfaqs' because it is not full-text indexed.

Source Error:


Line 148:            catch (Exception obj)
Line 149:            {
Line 150:                throw obj;
Line 151:            }
Line 152:            finally

Source File: e:\optavise.net2023\App_Code\DataAccess.cs    Line: 150

Stack Trace:


[SqlException (0x80131904): Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'searchfaqs' because it is not full-text indexed.]
   Website.DataAccess.LoadCommand(SqlCommand cmd) in e:\optavise.net2023\App_Code\DataAccess.cs:150
   claritylifeins_Search_Tool.Page_Load(Object sender, EventArgs e) in e:\optavise.net2023\Claritylifeins_Search_Tool.aspx.cs:34
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4110.0