System.Data.SqlClient.SqlException (0x80131904): Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'News' because it is not full-text indexed.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
at NVCMS.Modules.TinTuc.SqlDataProvider.FindContent_Count(Int32 control, Int32 PortalId, DateTime datefrom, DateTime dateto, String key, Int32 categoryid, String arrPhongBan, Int32 uid, Boolean isImage, Int32 type) in D:\_WORKING\HUBV2\BUH_V3\PROJECT\NVCMS.Modules.Tintuc\SqlDataProvider.vb:line 298
at NVCMS.Modules.TinTuc.NV_NewsController.FindContent_Count(Int32 control, Int32 PortalId, DateTime datefrom, DateTime dateto, String key, Int32 categoryid, String arrPhongBan, Int32 uid, Boolean isImage, Int32 type) in D:\_WORKING\HUBV2\BUH_V3\PROJECT\NVCMS.Modules.Tintuc\NewsController.vb:line 185
at DesktopModules.TinTuc.Display.Search.inc_SerachResult.LoadData() in G:\_BUHWEBSERVER\WWW\DesktopModules\NVCMS.TinTuc\Display\Detail\SearchResult.ascx.vb:line 110
ClientConnectionId:1e87f69c-6c08-4e0c-af58-9a01bc3a7cab
Error Number:7601,State:2,Class:16
Kết quả tìm kiếm