Devart Forums

Posted: **Wed 09 Nov 2016 17:45**

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

Posted: **Thu 10 Nov 2016 11:25**

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

Devart Forums

Incorrect syntax near 'with'

Incorrect syntax near 'with'

Re: Incorrect syntax near 'with'