How is SQL Prompt helping your team? Share your experience.
Invalid Object Error for Stored Procedures with OPTION (RECOMPILE)
I have noticed that when finding invalid opbjects , if the stored procedure being scanned has "OPTION (RECOMPILE)" within it, we get an invalid object returned with "A severe error occurred on the current command. The results, if any, should be discarded."
I assume this is a bug. Any ideas on a work around or a fix?
0 · Share on Twitter