Error message in Query Analyzer on SQL Server 2005
Home > IT Answers > SQL Server > Error message in Query Analyzer on SQL Server...
SQL Server Ask the Experts
2445 pts.
0
Q:
Error message in Query Analyzer on SQL Server 2005
SQL Server 2005, SQL Server errors, SQL Query Analyzer
I am trying to run the following command in Query Analyzer 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'.

Why might this be?
ASKED: Aug 19 2008  8:08 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
RetroCat
75 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
If you want to change the user name, use NAME not LOGIN:

ALTER USER [MY-LP79EFIWXO93login_a] WITH NAME = [MY-LP79EFIWXO93login_b]
Last Answered: Aug 20 2008  7:28 AM GMT by RetroCat   75 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0