Post reply

Moving databases

  • March 17, 2008 at 11:13 am

    #183352

    I'm moving a bunch of db's off a 2000 box onto a new 2005 box. Is there any quick way to find out what users have what access to the databases?

    I would like to know what access people have before I move. Once the db is moved I'm going to lock the access down to who really needs it.

  • March 17, 2008 at 1:03 pm

    #790515

    Could you use

    Script database users and database roles

    Script SQL Server logins

    in Generate SQL Script ... in SQL 2000?

  • March 18, 2008 at 1:04 am

    #790690

    Try

    sp_helplogins

    to find the logins previlages.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 18, 2008 at 7:36 am

    #790808

    Thanks, sp_helplogins is what I was looking for

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

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