Hi
This is when you are migrating from old server to new server.
Is it better to script out the logins and run the login script on new server?
OR
Use sp_help_revlogin and use the script created as output by sp_help_revlogin? What is the best practise.
Secondly, CREATE LOGIN [Domain\Login] FROM WINDOWS WITH DEFAULT_DATABASE = [master]; REVOKE CONNECT SQL TO [Domain\Login] --- so the revoke is making sure the user cannot use Sql authentication? They can only use windows auth?
Thanks!