Home Forums SQL Server 2005 Administering Questions about db_owner role. RE: Questions about db_owner role.

  • July 31, 2009 at 9:02 am

    #1032995

    2 Tim 3:16 (7/31/2009)

    Mayne the user didn't get matched up with the login.

    Go to Security - Login and look at the porperties for the login and see if the user database is checked for dbo.

    execute sp_change_users_login 'loginname','username'

    SQL DBA.