Identity Columns on replicated data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 27 Feb 2006 19:41 GMT

CREATE TABLE SALES
(sale_id INT IDENTITY (1,1),
sale_region CHAR(2) )

When replicated, the IDENTITY property is lost. If the Publisher crashed and
I wanted to restore the replicated data off the subscriber, I could manually
edit the table and turn on the IDENTITY property under Enterprise Manager. Is
there another way? I can not find a way to do this with the ALTER TABLE
statement. TIA

Reply to this Message

Hilary Cotter - 28 Feb 2006 02:08 GMT

The best way is to use a custom script in sp_addarticle to put the identity
property with the NFR clause on the subscriber.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> CREATE TABLE SALES
> (sale_id INT IDENTITY (1,1),
[quoted text clipped - 8 lines]
> there another way? I can not find a way to do this with the ALTER TABLE
> statement. TIA

Reply to this Message