Brian, jay,

thanks for your help

Tom

Thanks Jay,

It seems there is no easy way.

Tom

Yes, there are values.

But has that fact anything to do with a syntax error?

Still same error (syntax error!)

Tom.

There is no identity on that column nor any other column in the table

Syntax:

alter table HO_categorie

alter column p_cat int not null identity(1,1)

Server: Msg 156, Level 15, State 1,...

This is my problem:

I have an existing table, in that table there is a integer type column.

I want to set the indentity to on, on that column with a script.

When...

I get an error: incorrect syntact near identity. The problem is that 'identity(seed, increment)' can only be used to define a identity column. Or am I wrong.

Best regards Tom

I try'd that but whatif you want to switch it back on?

OK, but the column is also used as primary key, and is a part of a foreign key. I just wondered if there is an easy way...

BCP works fine,

Thanks a lot

Tom

Thanks Andy,

Had to look up BCP, I had never used it before

Tom