• I used google and found this link:

    http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell

    And put this together:

    -- ENABLE XP_CMDSHELL

    SP_CONFIGURE 'XP_CMDSHELL', 1

    RECONFIGURE WITH OVERRIDE

    GO

    SET NOCOUNT ON;

    DECLARE @FILENAME VARCHAR(50)

    , @BCPCOMMAND VARCHAR(2000)

    , @SERVER_NAME SYSNAME = @@SERVERNAME

    -- FILE PATH WHERE YOUR SQL SCRIPT WILL BE STORED

    SET @FILENAME ='C:\XXX\SQL_LOGINS_['+@SERVER_NAME+']_'+CONVERT(VARCHAR, GETDATE(), 112)+'.SQL'

    -- QUERY FOR LOG DETAILS

    SELECT 'EXEC SP_ADDLOGIN @LOGINAME = ''' + LOGINNAME + '''' AS LOGINAME

    ,', @DEFDB = ''' + DBNAME + '''' AS DEFDB

    ,', @DEFLANGUAGE = ''' + LANGUAGE + '''' AS DEFLANGUAGE

    ,', @ENCRYPTOPT = ''SKIP_ENCRYPTION''' AS ENCRYPTOPT

    ,', @PASSWD =' AS PASSWD

    , CAST(PASSWORD AS VARBINARY(256)) AS PASSWORD

    ,', @sid =' AS SID_HEAD

    , SID

    INTO TEMP

    FROM SYSLOGINS

    WHERE NAME NOT IN ('SA')

    AND ISNTNAME = 0

    -- BUILD BCP COMMAND

    SET @BCPCOMMAND = 'BCP "SELECT * FROM TEMP" QUERYOUT "'

    SET @BCPCOMMAND = @BCPCOMMAND + @FILENAME + '" -c -T' PRINT @BCPCOMMAND

    -- EXECUTE BCP COMMAND

    EXEC MASTER..XP_CMDSHELL @BCPCOMMAND

    -- CLEAN UP

    DROP TABLE TEMP

    GO

    -- DISABLE XP_CMDSHELL

    SP_CONFIGURE 'XP_CMDSHELL', 0

    RECONFIGURE WITH OVERRIDE

    GO