Incorrect syntax near 'ON'

[FredS]

This is part of a db update script stripped to bare bones, I executed this against SQLServer in the previous version of UniDAC without issues, now I get the error below. Something changed?

It uses TUniScript:

Code: Select all

  UniScript.NoPreconnect := False;
  UniScript.AutoCommit := False;
  ..
  UniScript.ExecuteStream(ResourceSream); 

-------------------------
PA2
-------------------------
Incorrect syntax near 'ON'.
-------------------------
OK
-------------------------

Code: Select all

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
Go

ALTER PROCEDURE [dbo].[WriteShareAccessList] 
 @ServerShareID bigint,
 @Access AccessType, 
 @Mask DWORD, 
 @FULLACCESS int, 
 @CHANGEACCESS int, 
 @READACCESS int, 
 @UserGroupSID nvarchar(64)
AS
declare  @CurrentMask DWORD;
declare @Exists bit;
BEGIN

  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  return 0
END

GO

[azyk]

Thank you for the information. We have reproduced the problem and will investigate it.

[FredS]

Hi azyk,

Needless to say this is a show stopper, cannot create nor update SQL-Server dbs at this time.

Fred

[FredS]

Still no update on this issue?

[azyk]

We have fixed this problem. This fix will be included in the next UniDAC build.

[FredS]

We have fixed this problem. This fix will be included in the next UniDAC build.

Thanks azyk, but that brings up the next Q; when will that be and are there interim fixes available?

[azyk]

We have answered you via email.