SQL Change Automation & Deferred Name Resolution

RyanCooper

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?

David Atkinson

Try running the Invalid Objects SQL Cop check using the tSQLt framework. This check will fail if invalid objects are identified. These docs should help if you intend to run tSQLt tests from SCA.

RyanCooper

Thanks David. I think that will work.