I found this script to script just the triggers from a sql 2008 database: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30222/
. Is that the only way to do it? Did MS really not give you a way to do it from SSMS without
including the table definitions as well? I can't believe that since you would have to delete a table's data just to change how its triggers work.
Hopefully, there's a way to do this from SSMS. Otherwise, I'll see if my copy of ApexSQL will do the trick.
Thanks in advance.