since the latest update of the SDAC components to version 7.3.15 I get errors on scripts containing EXECUTE statements.
I load text files into a TMSScript component and execute them.
Executing a script like
leads to an exception 'Syntax error near TRANSACTION'.DECLARE @DBVersion [varchar] (128)
SELECT @DBVersion = [Value] FROM [dbo].[InternalParameter] WHERE [ParamName] = 'DBVersion'
IF @DBVersion = '2.6.170'
BEGIN
BEGIN TRANSACTION
EXECUTE sp_rename N'dbo.Tmp_Product', N'Product', 'OBJECT'
SELECT @DBVersion = '2.6.171'
UPDATE [dbo].[InternalParameter] SET [Value] = @DBVersion WHERE [ParamName] = 'DBVersion'
COMMIT
END
GO
I have tested over one hundred scripts and every script where I use the MS SQL Server EXECUTE statement fails and the exception text always refers to the line just before the EXCUTE statement. I use this method for over 11 years now and it was never a problem until my latest update.
Can this be fixed?