Post reply

Logins

  • May 16, 2008 at 12:52 pm

    #182569

    Hi ,

    Is there any script to delete all the logins that don't have any mappings with the database?

  • May 16, 2008 at 1:26 pm

    #816704

    There's not specifically a builtin script for it, but feel free to write it yourself. It doesn't sound like it should be that difficult. Just off the top of my head I'm thinking it'll involve a couple cursors through the user DBs. But that's without looking into it at all.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 23, 2008 at 9:02 am

    #819752

    can you give me some hints in writing the code?

  • May 24, 2008 at 3:40 pm

    #820021

    there are some procedure u can use thier output:

    1- sp_helplogin

    2- sp_change_users_login

    ..>>..

    MobashA

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

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