public async Task AbleToMigrate_delayed_delivery_does_not_exist_should_indicate_problems() { await using var connection = new SqlConnection(connectionString); await connection.OpenAsync(); var sut = new MsmqTarget(new TestLoggingAdapter(), connectionString, schema); await using var command = connection.CreateCommand(); command.CommandText = string.Format(@" IF OBJECT_ID('{0}.{1}', 'u') IS NOT NULL DROP TABLE {0}.{1}; ", $"{MsmqSqlConstants.DelayedTableName(ExistingEndpointName)}", schema); await command.ExecuteNonQueryAsync(); var info = new EndpointInfo { EndpointName = ExistingEndpointName, ShortestTimeout = DateTime.UtcNow.AddDays(3), LongestTimeout = DateTime.UtcNow.AddDays(5), Destinations = new[] { ExistingDestination } }; var result = await sut.AbleToMigrate(info); Assert.IsFalse(result.CanMigrate, string.Join("\r", result.Problems)); }