Gustav Brock
gustav at cactus.dk
Fri Jun 8 08:08:43 CDT 2012
Hi all I'm new to triggers but I've managed to create this which works as intended: USE [PPT] GO /****** Object: Trigger [dbo].[T_VariantsTable_UTrig] Script Date: 06/08/2012 14:45:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================================= -- Author: Gustav Brock -- Create date: 2012-06-08 -- Description: Update field Created to time of update of record -- ============================================================= ALTER TRIGGER [dbo].[T_VariantsTable_UTrig] ON [dbo].[VariantsTable] FOR UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here DECLARE @id INT DECLARE @now DATETIME -- Retrieve ID of changed record. SELECT @id = (SELECT ID FROM deleted) -- Get current time without milliseconds. SELECT @now = DATEADD(SECOND, DATEDIFF(SECOND, '20000101', GETDATE()), '20000101') UPDATE VariantsTable SET Changed = @now WHERE ID = @id END However, when I open this in SMMS, this line has the last part red underlined: ALTER TRIGGER [dbo].[T_VariantsTable_UTrig] stating: Invalid object name 'dbo.T_VariantsTable_UTrig' Why is that? I have another trigger created by the Access upsize wizard with similar code: ALTER TRIGGER [dbo].[T_VariantsTable_ITrig] and nothing is underlined here. /gustav