Comments
2 comments
-
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.
-
Thanks David. I think that will work.
Add comment
Please sign in to leave a comment.
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?