• You are absolutely correct.

    You must use 3 part naming convention (Server.DB.Object) or even 4 part (Server.DB.Schema.Object) in order to get away with it.

    If your solution refers to 10 objects than it's convenient. If it has 150 - you're in a setup-script-must-have situation...