Home Forums SQL Server 2005 Administering How to sync users and logins in SQL2005 after restore RE: How to sync users and logins in SQL2005 after restore

  • Can you drop users when they are connected to a schema?

    Can you drop a schema that owns objects?

    To both questions the answer was 'No' for what I know. But I may be incorrect.

    If I am right, then dropping users is not an option. Then you need to sync the users and logins. This was always possible for SQL logins and Windows logins in SQL Server 2000 with the 'sp_change_users_login' stored procedure. But for some reason, Microsoft decided to change that stored procedure that it only works for SQL Server logins in SQL Server 2005.

    So the question remains:

    How to do a sync with Windows logins in SQL Server 2005?...