Kendra Little gives us a detailed rundown of deferred name resolution in SQL Server:
Have you ever tried to create an object in SQL Server, but it failed due to a missing table, column, or other dependency? If so, you’ve hit a case where SQL Server doesn’t offer ‘deferred name resolution’.
While these errors can be helpful when you’ve made a typo or accidentally used the wrong database, this can sometimes be a big hassle when you are…
– Deploying database code to set up a partial environment
– Deploying database code from version control to an empty database to ensure the code is valid
In this post, I walk through common scenarios and test whether deferred name resolution works or not.
Check it out for what is probably the most detailed look at the topic I’ve ever seen.
Comments closed