Home Forums SQL Server 2005 SQL Server 2005 Compact Edition How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 RE: How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

  • EXEC sp_change_users_login 'Auto_Fix', 'user'

    That syntax is deprecated and you should avoid using it where possible.

    i tries this

    ALTER USER [ram] WITH LOGIN [ram]

    but it giving following error :-

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'ram'.

    I typed "ALTER LOGIN" into my favourite search engine and I got lots of results telling me the exact syntax. You could do the same.

    John