Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

What is the best way to do this? File locations will be different on new server.<BR><BR>Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with ...