Hi Luis

I thought to copy the .sql o/p and running it manually. When I do that I found that the extract through sqlcmd did not work properly. Many places, it just extracted few portion.

sqlcmd -E -S server-d master -Q "set nocount on; exec master..sp_help_revlogin; set nocount off;" -o "c:\Logins.sql"

Do I have to modify the script so that It will extract the entire output while the proc sp_help_revlogin is being called via sqlcmd.?

Please suggest.