I have SQl Server 2005 SP1.I am running following query
ALTER USER [myuser] WITH LOGIN =[myuser]
I have created both user and login with name myuser.
but this query returns error
Msg 102, Level 15, State 1, Server ..., Line 1
Incorrect syntax near 'LOGIN'.
Same query can be run on SQL server 2005 SP3,SQL Server 2008...
ALTER USER [myuser] WITH LOGIN =[myuser]
I have created both user and login with name myuser.
but this query returns error
Msg 102, Level 15, State 1, Server ..., Line 1
Incorrect syntax near 'LOGIN'.
Same query can be run on SQL server 2005 SP3,SQL Server 2008...
Comment