Post reply

Dropping Users from the database that does not have matching syslogin

  • January 20, 2009 at 3:44 pm

    #217664

    Hi guys,

    My subject says it almost I have to mention. I need to drop all the users from all of the databases that does not have matching syslogins , how can I drop them with the script/

    Thanks,

  • January 21, 2009 at 1:02 am

    #930148

    srawant (1/20/2009)

    Hi guys,

    My subject says it almost I have to mention. I need to drop all the users from all of the databases that does not have matching syslogins , how can I drop them with the script/

    Thanks,

    There are ample scripts on this site that will help you find out orphaned users and create logins for them. You can modify the script to delete the ID instead of creating logins for them.

    http://www.sqlservercentral.com/articles/Administering/migratingloginstoanotherserver/1140/


    Pradeep Singh

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

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