ALTER USER [myuser] WITH LOGIN =[myuser]
This query returns error in one of the SQL Server 2005 SP1 installation. Error is
Incorrect syntax near 'LOGIN'
Several things
[]
around the user name and login you want.Try this:
ALTER USER myuser WITH LOGIN = myLOGIN
See the ALTER USER
documentation on MSDN.
The problem seems to be a bug in SQL Server 2005.
It is fixed at SP2. So, The the fix is to upgrade it to SP2 or above.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With