I'm using this line to run an EXE. Sometimes the EXE is successful, and sometimes it's not. Is there a way to get whatever was displayed in the command window after it runs? I need to take a different action afterward depending on whether it was successful or not.
EXEC MASTER.dbo.xp_cmdshell @Merge_Script, no_output