This is the first time I am trying the Exchange so please be forgiving if I do not know the exact protocol for submitting requests. We have just upgraded to SQL Server 2012. When I execute a stored procedure through SSMS I get a "Command(s) completed successfully" even though I know for a fact there are invalid table names in the stored procedure. I have tried toggling the NOEXEC but it did not do anything. Can someone please help me out on this? Thank you in advance.