[dba-SQLServer] Help on Incorrect syntax near '‘'.

Just a quick idea, as an example take the line

SET @DisplayName = ‘System Administrator’ – Display name (Not always used)

do you actually have the – Display name (Not always used) on the line in
your code, if so it only looks like a single dash '-' try replacing the
single - with two dashes -- so that the SET line above becomes

SET @DisplayName = ‘System Administrator’ -- Display name (Not always used)


Paul


On 11 July 2014 00:25, J- P <jnatola at hotmail.com> wrote:

> seems like formatting was lost here is the error
>
> Incorrect syntax near '‘'
>
>
>
>
>
>
>
>
>
> Jean-Paul Natola
>
>
>
>
> ----------------------------------------
> > From: jnatola at hotmail.com
> > To: dba-sqlserver at databaseadvisors.com
> > Date: Thu, 10 Jul 2014 19:22:44 -0400
> > Subject: [dba-SQLServer] Help on Incorrect syntax near '‘'.
> >
> > So i'm trying to reset the BES password and this error keeps showing
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 13
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 14
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 15
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 21
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 23
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> > Msg 102, Level 15, State 1, Line 24
> >
> >
> >
> > Incorrect syntax near ''.
> >
> >
> >
> >
> >
> >
> >
> > DECLARE
> > @DisplayName VARCHAR(256),
> > @Authentication VARCHAR(256),
> > @AuthenticatorTypeId INT,
> > @AuthenticatorInstanceId INT,
> > @ExternalAuthenticatorId VARCHAR(255),
> > @EncryptedPassword VARCHAR(256)
> >
> > /************************************************************
> > Start of editing required section
> > *************************************************************/
> >
> > SET @DisplayName = ‘System Administrator’ – Display name (Not always
> used)
> > SET @Authentication = ‘BAS’ – ‘BAS’ for BAS authentication
> > SET @EncryptedPassword = ’2951a982f568f15567b7c6e0e50990b9′ – Encrypted
> string of password ‘blackberry’
> >
> > /************************************************************
> > End of editing required section
> > *************************************************************/
> >
> > IF @Authentication LIKE ‘BAS’
> > BEGIN
> > SET @AuthenticatorTypeId = 0 – Set to 0 for BAS
> > SET @AuthenticatorInstanceId = 0 – Set to 0 for BAS
> > SET @ExternalAuthenticatorId = NULL
> >
> > EXEC SetUpBASorADAuthentication @DisplayName, @AuthenticatorTypeId,
> @AuthenticatorInstanceId, @ExternalAuthenticatorId, @EncryptedPassword
> >
> > END
> > GO
> >
> >
> > Jean-Paul Natola
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com