Right now I can execute a CREATE PROCEDURE or an ALTER PROCEDURE script with incorrect table and column references in the MS SQL Server Management Studio and using ADO.NET commands. The scripts run fine, but if I open the created stored procedures on MS SQL Server using Management Studio, then I'll see incorrect tables and columns being highlighted in red. I want to get those errors when creating or altering stored procedures. How do I do that?

1 Answer 1


No, you can't change the way deferred name resolution works. See this Connect item, this Connect item and also this section on Erland Sommarskog's "SET STRICT_CHECKS ON" proposal: http://www.sommarskog.se/strict_checks.html#killDNR

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.