"Is it really necessary to include the database name in all object references? I've always included schema.object but not database name as it's impossible to deploy the same code base on many databases if you hardcode the db name..."

Hi,

Although SQLBOL says use DBname.SchemaName.ObjectName, I have found in my practical experience that SchemaName.ObjectName itself suffices. I have not found any unnecessary recompilations due to usage of SchemaName.ObjectName. But I have when using just ObjectName.