SQL Change Automation & Deferred Name Resolution


With Deferred Name Resolution, T-SQL allows you to create a Stored Procedure which references a table that does not exist.

This is fine in most use cases, but when building a database via SCA, this is not ideal (at least for our purposes). Since the t-sql syntax is valid, no errors are thrown by SCA.

If a user commits a proc which references a non-existing table, I want the build validation to fail. Otherwise, it gives the developer a false sense of security because their build 'passed'.

Has anyone ran into this issue and found a workaround/solution?

Best Answer

Answers

Sign In or Register to comment.