Incorrect syntax near 'with'

[Marcin Ł.]

Hello

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

When I try to execute then I get the message:

Incorrect syntax near 'with'.

Please let me know what I need to do to make it work again.

Regards
Marcin

[ViktorV]

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of SDAC.