hi alpha thx for ur apps, but i hv some error message, pls help how to fix it
Code:
12-Oct-14 9:07:09 PM : [DB Data Validator] - EQ Check failed
Exception:
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'.
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at rSec.Database.sendSelectQuery(Databases db, String Query)
at rSec.DBTestsRunner.RunEQ()
at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg)
ClientConnectionId:e1b19170-7827-417d-a798-302e6eee1673
then i try use this query for fix problem
ALTER TABLE [dbo].[CharInfo] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO
ALTER TABLE [dbo].[CharInfo] ADD CONSTRAINT [DF_CharInfo_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO
but sql showing error message
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'COLUMN'.
Msg 1752, Level 16, State 0, Line 2
Column 'EQ_Changed' in table 'CharInfo' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.