Tag Archives: SQL server

Migrating SQL Server logins

Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During some recent migration work I realised that SQL Server Management Studio could do most of the work of sp_help_revlogin. I … Continue reading

Posted in Security, SQL Server, T-SQL, Uncategorized | Tagged , | 8 Comments

Quick Tip: Migrating a SQL Server Mirroring Witness server.

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole listĀ of things to think about when migrating from one SQL … Continue reading

Posted in Database options, Disaster Recovery, SQL Server, T-SQL | Tagged , , | 3 Comments