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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2009-07-30 : 20:53:45
|
| I need to generate the scripts for drop and create scripts for the existing triggers of the tables in database..Please help.. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-30 : 21:08:57
|
use SQL Server Management Studio, right click on the triggers and choose SCRIPT TRIGGER
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:04
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:17
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:27
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:33
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:46
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2009-07-31 : 10:10:56
|
| Thanks KhtanI have 100's of tables..I want in one shot to create and drop triggers instead of selecting one by one.. |
|
|
|
|
|
|
query