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?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
migrated from serverfault.com Feb 22 '12 at 14:11
|
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 |
|||
|
|
