Recently I updated SQL Server Data Access Components to version 7.3.
After the update scripts executed by TMSScript unfortunately stopped working.
Code: Select all
CREATE TRIGGER [dbo].[TrInsSelfTest] ON [dbo].[SelfTest] WITH EXECUTE AS CALLER FOR INSERT AS DECLARE @ID int, @Position int, @ParentID int BEGIN SET NOCOUNT ON -- ....................... END
Please let me know what I need to do to make it work again.Incorrect syntax near 'with'.