wibench
asked on
SQL Server 2012 execute getting "Command(s) completed successfully" even though there are invalid object names.
Hello Folks,
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.
Sincerely,
Thomas
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.
Sincerely,
Thomas
Can you try executing it from another machine ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.