Category: SQL

Cause: The error is caused by either database is not selected in Job Step or the database have been renamed. Solution “Edit Job Step” and select a database as shown below:

Simple and easy to use trigger template: Create Trigger [dbo].[Trigger_IU] on [dbo].[TableName] after INSERT, UPDATE, DELETE as begin Set nocount on; declare @activity char; set @activity = ”; declare @i int, @d int; select @i = count(*) from inserted; select @d = count(*) from deleted; if @i > 0 and @d = 0 begin set