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.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-10-25 : 10:07:48
|
| How to disable triggers in sql server 2000 using T-SQL?------------------------I think, therefore I am |
|
|
SQLCode
Posting Yak Master
143 Posts |
Posted - 2004-10-25 : 10:24:06
|
| Disable triggers:sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"Enable:sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? ENABLE TRIGGER all" |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-10-25 : 16:54:03
|
| How to disable the replication triggers using T-sql?------------------------I think, therefore I am |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-25 : 23:20:46
|
quote:
Originally posted by ravilobo
How to disable the replication triggers using T-sql?------------------------I think, therefore I am
just stop the subscription agent from synchronizing?--------------------keeping it simple... |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-10-26 : 05:55:35
|
| Stopping the subscription will not stop me from entering into msmerge_tombstone and msmerge_contents tables. The data will be inserted into these table when ever i modify the data. Even if the subscription is stopped, once i start the the subsription data will be synchronised.------------------------I think, therefore I am |
|
|
|
|
|
|
Disable triggers