Contents tagged with orphan

• Fix Orphaned Users When Moving SQL Server Databases

  Tags: orphan, orphaned, user, SQL Server, moving, migrating

  Sunday, November 26, 2023 3:03:41 PM

  No Comments

  Firstly to report on whether there are any orphaned users present for a database, run the following query against the DB;

  EXEC sp_change_users_login 'Report'

  Then to fix any identified orphaned … more