Monday, August 29, 2011

Generate trigger script using sys.all_sql_modules in SQL Server 2008

Generate trigger script using sys.all_sql_modules in SQL Server 2008





-- Generate trigger script using sys.all_sql_modules in SQL Server 2008
Select definition+CHAR(10)+'GO' AS '--definition' from sys.all_sql_modules 
where object_id in 
 (Select object_id  from sys.objects where type = 'TR')

No comments:

Post a Comment