Referencing objects from another database on the same server?

GenialArun

I have a database with enterprise data on it and will have to referencing the views/functions/tables into my application database.

How can I achieve this overcoming the 3-part naming restriction?

Sergio R

Rather than use the default option of using SQL Local DB, you can use a Temporary Database where those references will be valid

GenialArun

Is there any sample that  I can refer to regarding cross database dependency handling?

Your suggestion of using LocalDB is not clear to me.

Sergio R

My suggestion was not using Local DB, which is the default option in SQL Change Automation.
You should set a Temporary Database in a SQL Instance where those references are valid.

GenialArun

How can we set the configuration for the automatic builds to target to a specific server instead of the LocalDB?