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

greatly appreciated, i will test and report my findings.

thank

  

Jean-Paul Natola

 


> Date: Fri, 11 Jul 2014 01:30:59 +0100
> From: paul.hartland at googlemail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>