backup users

  • HI ALL,

    i do script to backup users . but when i restore users it is not mapping to there database and the user also can't loging.

    there is sign on the user indicate that it is down.

    sorry for my language.

  • Similar Topic:

    http://www.sqlservercentral.com/Forums/Topic518031-357-1.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Are you scripting just database users or logins also? The thread that Henrico references suggests using MS's sp_help_revlogin which scripts logins, including their default database. A newer version of the KB article is here: http://support.microsoft.com/kb/918992.

    Greg

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

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