CREATE PROCEDURE [dbo].[SmartConnectProcedure]
	   @ErrorMessage VARCHAR(255) OUTPUT,
	   @Error Int OUTPUT

AS BEGIN
BEGIN TRY

/***** Your Code Here *****/

END TRY
BEGIN CATCH
        SET @Error = ERROR_NUMBER() 
		SET @ErrorMessage = ERROR_MESSAGE()
    END CATCH
	IF @ERROR is NULL
	BEGIN
	SET @Error = 0 
	END
END


GO