To view the results of components in an analysis, after running the analysis, switch to the Results view or from the contextual menu of the component, select View Results.
For a detailed description of how to export a chain as a stored procedure, see Exporting an Analysis as a Stored Procedure.