Sql Server Script Generator
-- Purpose: To Drop Trigger if Exists --========================== SELECT ' IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N''' + name + ''')) ' + ' DROP TRIGGER ' + name + ';' FROM dbo.sysobjects WHERE TYPE = 'TR' --Purpose: To Drop Triggers name starts with I_ or U_ or D_ if Exists ----------------------------------------------------------------------------------- SELECT ' IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N''' + name + ''')) ' + ' DROP TRIGGER ' + name + ';' FROM dbo.sysobjects WHERE TYPE = 'TR' AND ( name LIKE 'I_%' OR name LIKE 'U_%' OR name LIKE 'D_%') --To Reseed Table's Identity Column --========================== DBCC CHECKIDENT (PPP_tblHeadGroup, reseed, 1) DBCC CHECKIDENT (PPP_tblHeadGroup, reseed) -- Purpose: Data Cleansing Script Ge...