弱弱地问

[cattydid]

1。SQL server 2000 可否安装在xp上？(10 pt)

2. Transaction Replication 可否在有constraint的表中实现？即假设有两张表，中间有Foreign Key关联，当一张表进行更新时，其Transaction 可否复制到另一个Server从而更新里面的同张表？(20 pt)

有人在做replication上有经验的，可否告知一些注意事项，非常感谢

[chinaandys]

up

[dellair]

1.可以的
2.不可以

[hurrah_yule]

1. 可以

2. 可以通过程序实现( server本身好象不行）

[cattydid]

thanks for your reply, actually, for q2, i have done the experiment,the answer is yes. Basically, the transactional replication is just copying the command such as insert, delete and update, so if the command can be executing at one server then it can also be executed at another server...but can not drop tables....