Error message in Query Analyzer on SQL Server 2005
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 19, 2008 8:08 PM
UPDATED:
August 20, 2008 7:28 AM
Answer Wiki:
If you want to change the user name, use NAME not LOGIN:
ALTER USER [MY-LP79EFIWXO93login_a] WITH NAME = [MY-LP79EFIWXO93login_b]
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
