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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from serverfault.com Feb 22 '12 at 14:11

This question came from our site for system and network administrators.

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.