Thom A (12/8/2016)
What you're looking for is BEGIN TRY:
BEGIN TRYEXEC thisspdoesnotexist_sp;
END TRY
BEGIN CATCH
RAISERROR('Enter your error message here',1,0);
END CATCH
That only points out the error but does not continue the execution of the rest