I am trying migrate databases and along with the database I am trying to also migrate the users without having to re-map the users. I was trying to recreate the windows user with the old server SID. Is this possible? I have an example of the code I have been trying to use but SQL gives me an incorrect syntax error.
USE [master] GO CREATE LOGIN [domain\ntuser] FROM WINDOWS WITH DEFAULT_DATABASE=[master], SID=0x01000000000000000000000000000000000000000000000000000000; GO
Msg 102, Level 15, State 1, Line 6 Incorrect syntax near '0x01000000000000000000000000000000000000000000000000000000'.