Receiving an error in Quality Assurance on SQL Server 2005

Tags:
Quality assurance
SQL Server 2005
SQL Server errors
I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Do you have any idea why?

Answer Wiki

Thanks. We'll let you know when a new response is added.

That syntax appears correct. The only thing I can think of would be to put a GO command between the USE temp and the ALTER USER command.

Are those Windows accounts which are mapped as Logins? Perhaps you need the “” between the machine name and the login?

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,005 pointsBadges:
    report
  • Db23
    Hmm, how did this post appear here, this looks like a question I asked but didn't posted.. Anyway, these are window account and I have try it with the '\', just wondering MrDeeny this is a valid SQL Server 2005 command, are you able to run the instruction on your SQL Server 2005?
    290 pointsBadges:
    report
  • ITKE
    Db23 Some questions that you may submit to the Ask The Experts section on any TechTarget site like SearchSQLServer.com will be posted on IT Knowledge Exchange. The goal is to get you the quickest answer possible.
    342,195 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following