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
 Import/Export (DTS) and Replication (2000)
 Replicating Triggers 2

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-22 : 07:35:39
miha writes "RocketScientist (Replicating Triggers on 08/14/2000) answer Miles that is not possible in MS SQL 7.0. Is it possible in MS 2000 (MSDE version)?



LP miha"

Tim
Starting Member

392 Posts

Posted - 2002-11-24 : 19:37:21
I found in sql7 that it does not *consistently* replicate triggers, views, sp's, or contraints.

My workaround was to script this and have the application run the scripts locally after replication (SQLMerge activex control) was compelte. That ensures all objects are as they should be.

I have not doen SQL2k replication yet so can't answer.

----
Nancy Davolio: Best looking chick at Northwind 1992-2000
Go to Top of Page
   

- Advertisement -