Identity Column

Would like to know how to use SQL 2000 command to modify a IDENTITY column
previously defined as YES...and now need to change it to Yes (Not For
Replication).
Thanks
There is no simple SQL command for that. You have to drop and recreate the
column. If you use Enterprise Manager, you can change the property and then
generate a script (third button from the left) which you can save, study and
run alter.
Jacco Schalkwijk
SQL Server MVP
"CH" <CH@.discussions.microsoft.com> wrote in message
news:5AD5D775-0125-471D-B9ED-EC8A6428099A@.microsoft.com...
> Would like to know how to use SQL 2000 command to modify a IDENTITY column
> previously defined as YES...and now need to change it to Yes (Not For
> Replication).
> Thanks
|||Thanks for your reply. I believe that there's a command to change the
identity. Thanks again.
"Jacco Schalkwijk" wrote:

> There is no simple SQL command for that. You have to drop and recreate the
> column. If you use Enterprise Manager, you can change the property and then
> generate a script (third button from the left) which you can save, study and
> run alter.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "CH" <CH@.discussions.microsoft.com> wrote in message
> news:5AD5D775-0125-471D-B9ED-EC8A6428099A@.microsoft.com...
>
>