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?
migrated from serverfault.com Feb 22 '12 at 14:11
This question came from our site for system and network administrators.