Unanswered: Script for changing SEED and INCREMENT
Folks, I apply SNAPSHOT to subscribers weekly. All tables at publisher having IDSEED columns r configured with SEED 2, INCREMENT 2.
After SNAPSHOT is applied; i want all tables at subscriber with IDSEED columns to SEED 1, INCREMENT 2.
--SEARCH TABLES WITH IDENTITY COLUMNS DEFINED
SELECT A.name ,B.NAME FROM syscolumns A JOIN SYSOBJECTS B ON A.ID=B.ID
WHERE B.TYPE='U' AND B.STATUS NOT LIKE '-%' AND A.status = 0x80
There r more than 100 tables; some columns r defined INT and some BIGINT.
Any help in changing the idseed property of the columns at subscribers??? Thanx!