Re: SQL User SID format?


"Laurentiu Cristofor [MSFT]" <Laurentiu.Cristofor@xxxxxxxxxx> wrote in message news:%233QKDTudHHA.2128@xxxxxxxxxxxxxxxxxxxxxxx
When you move databases to another server, you can remap users to logins using sp_change_users_login - however, this will only work for SQL logins/users. Starting with SQL Server 2005 SP2, we have added the capability to remap a user to a login with new ALTER USER syntax - I mentioned this at: http://blogs.msdn.com/lcris/archive/2007/02/19/sql-server-2005-some-new-security-features-in-sp2.aspx. The new ALTER USER syntax works for remapping both SQL and Windows logins/users, so it should allow you to do what you need in the easiest way.


Thanks Laurentiu, that ALTER USER command looks useful.
James

.