Hi,

I am trying to get Spring batch working in sql server 2005.

SQL server does not allow creating two columns with datatype TIMESTAMP.

I am using this query to create a new table but does not work as SQL server does not allow us to create a table with more than one datatype TIMESTAMP.

CREATE TABLE [BATCH_STEP_EXECUTION](
[STEP_EXECUTION_ID] [bigint] NOT NULL,
[VERSION] [bigint] NOT NULL,
[STEP_NAME] [varchar](100) NOT NULL,
[JOB_EXECUTION_ID] [bigint] NOT NULL,
[START_TIME] [timestamp] NOT NULL,
[END_TIME] [timestamp] NULL DEFAULT (NULL),
[STATUS] [varchar](10) NULL,
[COMMIT_COUNT] [bigint] NULL,
[READ_COUNT] [bigint] NULL,
[FILTER_COUNT] [bigint] NULL,
[WRITE_COUNT] [bigint] NULL,
[READ_SKIP_COUNT] [bigint] NULL,
[WRITE_SKIP_COUNT] [bigint] NULL,
[PROCESS_SKIP_COUNT] [bigint] NULL,
[ROLLBACK_COUNT] [bigint] NULL,
[EXIT_CODE] [varchar](20) NULL,
[EXIT_MESSAGE] [varchar](2500) NULL,
[LAST_UPDATED] [timestamp] NULL);

Like wise, we have other tables, which has more than one timestamp column in the table, that we have to create to enable database repository. How can this be achieved?

Thanks.