What statements can not be used with replication?

  • So I am looking into this subject to find out what developers cannot use in an environment where replication is active. I found out about the drop table and the truncate table, which can not be used. I wonder, are there more statements like that? Is there a list somewhere with unusable statements in a replicated environment?

    Greetz,
    Hans Brouwer

  • Altering primary key I do not think is allowed. You did not say what kind of replication you have.

    -Roy

  • The kind of replication: transactional. But I am interested in the whole replication spectrum. I find all kind of info bits on this subject, but I dunno if I forget something. That's why I am curious about some list with what programming/design consequences replication has.

    Greetz,
    Hans Brouwer

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply