Post reply

Replacement of syslogins table?

  • May 17, 2007 at 11:27 am

    #117283

    What equates to the syslogins table under 2005? I'm trying to create a script to pull login info & password from 2005 server in order to migrate the security. I have this for 2000 but I know the tables are different. I see a sysxlgns table which looks similar but I can't seem to query from it. I thaought I heard about a "hidden" DB that contains this info as a View?

    I know I need to take some Admin classes on 2K5 but time vs. DBA resources has been holding this up.

    Any hint on this would be greatly appreciated!!!

    -Mike

  • May 18, 2007 at 7:25 am

    #707434

    Try the system view sys.sql_logins.

    http://msdn2.microsoft.com/en-us/library/ms174355.aspx

    jg

  • May 18, 2007 at 9:16 am

    #707489

    DMV 

    sys.server_principals

     

    -WM

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

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