InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 16:35:14 GMT20http://www.sqlservercentral.com/Forums/Topic1393963-203-1.aspxWhat do you mean by execute?Do you want to add them to the tables in the database - if so see my previous post.Do you want to cause the triggers to run by updating the underlying tables - if so see my previous post.Something elseMaybe you want the triggers to be added to the tables in db1 and update the tables in db2.In which case use the inserted and deleted tables to run the updates.Fri, 07 Dec 2012 07:11:39 GMTnigelrivetthttp://www.sqlservercentral.com/Forums/Topic1393963-203-1.aspxI want to take only Triggers in Sql server 2008 R2 database to execute in another database.The Database having more than 25 triggers instead of excuting individually i want to take and execute 25 triggers at a timeFri, 07 Dec 2012 07:04:31 GMTskgudi2009http://www.sqlservercentral.com/Forums/Topic1393963-203-1.aspxDo you mean you want to copy the triggers to the other database?Right click on the database and generate scripts.Under scripting options, advanced you can select to script triggers.You should be able to create a script of all the triggers which you can then run in the other database.You can probably also do this via ssis.If you want to exercise the triggers then you will have to look at them individually and see what updates to the underlying tables you need to make.Fri, 07 Dec 2012 03:57:51 GMTnigelrivetthttp://www.sqlservercentral.com/Forums/Topic1393963-203-1.aspxYour caps lock appears to be stuck, and I don't appreciate being shouted at...Now, can you explain in a little more detail what you're trying to do here?Fri, 07 Dec 2012 03:33:48 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1393963-203-1.aspxI HAVE HAVING 2 DATABASES 1 IS HAVING MORE THAN 25 TRIGGERS.I HAVE TO TAKE ALL 25 TRIGGERS AT A TIME AND EXECUTE IT IN ANOTHER DATABASE AT A TIME WITHOUT EXECUTING INDIVIDUALLY IS IT POSIBLE/Fri, 07 Dec 2012 03:27:14 GMTskgudi2009