How to check if Alter view/stored proc script has run successfully
Check sys.objects for the row that has the right value in name and see if the modify_date column is newer than when your script started.

SELECT SYSDATETIME() AS ScriptStart
INTO #scriptstart;
GO
ALTER VIEW ...
GO
ALTER PROC ...
GO
SELECT name
FROM sys.objects
WHERE modify_date &gt; (SELECT ScriptStart FROM #scriptstart);


This will list all the objects that have changed since your script started. You could join to sys.schemas if you care enough... :)