Post reply

Need to drop Login from server.

  • November 4, 2021 at 9:26 pm

    #3948075

    how do I overcome this error?

    deleted user from databases, and this msg still comes/

     

    Likes to play Chess

  • November 4, 2021 at 10:02 pm

    #3948085

    Edit: Wrong Answer

    • This reply was modified 3 years, 1 month ago by  rothj.

  • November 4, 2021 at 10:05 pm

    #3948100

    That is not an error - it is a warning.  When you delete a login - if that login is associated with a user in any database that user will not be deleted and will become orphaned.  If you want to get rid of an account from all databases and the login, then you need to drop the user for each database and then drop the login.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • November 4, 2021 at 10:28 pm

    #3948103

    thanks. resolved.

    Likes to play Chess

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply