• /*********In master.dbo.sp_help_revlogin*******/

    --Replace "print" command with "SELECT"

    create table test (a varchar(4000))

    insert into test

    execute master.dbo.sp_help_revlogin

    exec master..xp_cmdshell 'bcp "master.dbo.test" out "\\location names\example.txt" -c -T -SServername '

    😎

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/