Incorrect syntax

I am inserting an SQL query I found online to create a user, to a program that runs on SQL databases. The passwords have been lost to this program that is why I am trying to run the query. Here is my code and error.  I am using SQL server 2008

INSERT INTO [dbo].[OrionUsers]
(Name, AuthURI, Admin, Disabled, Visible, Interactive, Removable, Editable)
VALUES (‘epoadmin’,'auth:pwd?pwd=7LTSeirrzM8EjqttaozV4cSiPGQWi8w3',1,0,1,1,1,1)

Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '‘'.
Msg 105, Level 15, State 1, Line 3
Unclosed quotation mark after the character string 'auth:pwd?pwd=7LTSeirrzM8EjqttaozV4cSiPGQWi8w3',1,0,1,1,1,1)
'.
LIBBBAsked:
Who is Participating?
 
RyanProject Engineer, ElectricalCommented:
It looks like your single quotes have changed.  Delete them and retype them in.  All 4 of them, though I think its just the ones on the 2nd field (AuthURI)
0
 
LIBBBAuthor Commented:
Worked perfect, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.