identity not for replication

microsoft.public.sqlserver.programming

11 Aug 2006 11:29 PM

Liannekwock

Hello,

Does any one know how to alter the column propterty from identity (yes) to
identity(not for replication) via TSQL.

Many thanks,
Lianne

12 Aug 2006 12:36 AM

Hari Prasad

Hi,

AS far as I know you need to drop and recreate the table. If its a small
table go to design mode in enterprise manager (for sql 2000)
and include that option (NOT FOR REPLICATION)and save it . THis will drop
and recreate the table.

Thanks
Hari
SQL Server MVP

Show quote

"Liannekwock" <Liannekw***@discussions.microsoft.com> wrote in message
news:99F993F7-8934-4A41-B6C5-49584B3A80DD@microsoft.com...
> Hello,
>
> Does any one know how to alter the column propterty from identity (yes) to
> identity(not for replication) via TSQL.
>
>
> Many thanks,
> Lianne