Recently I updated SQL Server Data Access Components to version 7.3.
After the update scripts executed by TMSScript unfortunately stopped working.
Example:
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'.
Regards
Marcin