Posted on 2012-08-17
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)
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)