I've never seen this before. Any suggestions on a fix?Could not validate ac_transactions Updates
Exception: The index '_dta_index_ac_Transactions_48_837578022__K3_1_2_4_5_6_7_8_9_10_11_12_13_14_15_16_17' is dependent on column 'AVSResultCode'. ALTER TABLE ALTER COLUMN AVSResultCode failed because one or more objects access this column. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at CommerceBuilder.Licensing.h.b(SqlConnection A_0) at CommerceBuilder.Licensing.h.f(SqlConnection A_0)
I suspect something added by the SQL Database Profile/Analyzer has now created an unexpected constraint. That would explain the odd _dta_index name. Maybe I should just delete that index?