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

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
>