• i tried to run this EXEC master..sp_help_revlogin from the source but still the output is only one..

    /* sp_help_revlogin script

    ** Generated Sep 24 2012 1:11PM on JHOLS\SQL2000 */

    /***** CREATE LOGINS *****/

    -- Login: BUILTIN\Administrators

    IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE [name] = 'BUILTIN\Administrators')

    CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS

    /***** SET DEFAULT DATABASES *****/

    -- Login: BUILTIN\Administrators

    ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=[master]

    /***** SET SERVER ROLES *****/

    -- Login: BUILTIN\Administrators

    exec master.dbo.sp_addsrvrolemember @loginame='BUILTIN\Administrators', @rolename='sysadmin'