Incorrect syntax near 'ON'
Posted: Fri 17 Apr 2015 01:52
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:
-------------------------
PA2
-------------------------
Incorrect syntax near 'ON'.
-------------------------
OK
-------------------------
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