locked
Orphaned Users; sp_change_users_login invalid parameter RRS feed

  • Question

  • Hello,

    how can i fix users with underscore in username?

        EXEC sp_change_users_login 'Report'
        /*
        DWH    0x3AF81EDF67D6E6468F7DE39D30A16403
        OLAP_CLIENT_1    0xC0897CA2D46B3F4D97D64BF3FE5EFD86

        */

        EXEC sp_change_users_login 'Auto_Fix', 'DWH' --ok
        EXEC sp_change_users_login 'Auto_Fix', 'OLAP_CLIENT_1' --invalid parameter

    Thank you

    best regards

    Tuesday, November 27, 2012 11:23 AM

Answers

All replies