Does anyone have any documentation or best practices when you have a database of stored procedures that reference tables from other databases that are on the same server. Would you recomend synonums or fully qualify the database.table name in the stored procedures?
Let's let you make the decision after I give you some facts in the form of a question...
What would you rather do if they move or rename a database? Repoint several dozen synonyms or find everywhere in all code where you need to change the 3 and 4 part naming when it does eventually happen to you?
Obviously, my recommendation is to ALWAYS use ONLY the two part naming convention for ALL user objects in code. Nothing more and nothing less.
And, yeah... it's pretty easy to write code that will repoint all of your synonyms.
18 People are following this question.
