SQL script that writes sql (DLL or DML) script for DBA and Developer for MS SQL Server 2005 or 2008 or R2
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