Not for replication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Not for replication

Author

Topic

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-09-20 : 19:05:47

Hi Gurus !!!

I wanna implement NOT FOR REPLICATION on tables that are already there in the database.Please let me know the procedure to implement this....

Thanks & Regards
Chander

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-20 : 19:08:30

If you have SP4, use ALTER Table syntax to set the NOT FOR REPLICATION property. chck out books on line for proper syntax.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-09-20 : 19:11:24

Can u please provide me the syntax for this

Thanks
chander

quote:
Originally posted by dinakar

If you have SP4, use ALTER Table syntax to set the NOT FOR REPLICATION property. chck out books on line for proper syntax.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-20 : 19:28:34

As mentioned earlier, please put some effort and check books on line.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-09-20 : 19:37:22

Hi

I have checked my version of sqlserver and found that SP4 is not there. My servers version is sqlserver 2000 with service pack 1. please tell me can i use alter table for this purpose or not, If not then How toimplement not for replication ?

Thanks
chander

quote:
Originally posted by dinakar

As mentioned earlier, please put some effort and check books on line.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-20 : 19:53:20

If your version < SP4 then you have to do it manually. Go th your table design view, select the column, if you look at the bottom of your screen, click on the "Identity" property, From the dropdown, select Yes (Not for Replication).

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2007-09-20 : 20:12:57

Hi

I have tryed this method before posting into sqlteam but this gives me error as follow

'tbl_DealsDetails' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tbl_DealsDetails' because it is being used for replication.

Please advice ...

Thanks
chander

quote:
Originally posted by dinakar

If your version < SP4 then you have to do it manually. Go th your table design view, select the column, if you look at the bottom of your screen, click on the "Identity" property, From the dropdown, select Yes (Not for Replication).

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-20 : 22:07:22

BTW, this change needs to be made on the subscriber. not on the publisher.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources