How to fix the wrong syntax next to "INPUT" in SQL Server 2005

Question

ALTER USER [myuser] WITH LOGIN =[myuser]

This query returns an error in one of SQL Server 2005 Service Pack 1 (SP1). Error

Incorrect syntax near 'LOGIN'

Answer 1

The problem seems to be a bug in SQL Server 2005.

It is fixed on SP2. So the fix is ​​to upgrade it to SP2 or higher.

Answer 2

Few things

• You do not need to use []around the username and login you want.
• It seems you are trying to change the login for yourself. It may not be right.

Try the following:

ALTER USER myuser WITH LOGIN = myLOGIN

See the documentation ALTER USERon MSDN.

Answer 3

ALTER LOGIN Login WITH name = NewLogin