Having several DB projects-Best way to reference databases from withing a view or stored procedure

[BeeTrees]

Hi all,

I want to know the best way to have several database projects in a solution and be able to reference those other databases from within a view or stored procedure without getting error messages. Currently i have a solution having number of db projects and references. But i get reference errors. I can fix the issue short term by messing around with the database references I’ve added but after a couple of month it starts again. Any suggestion to do it best way.

Thanks

 

[johnherman]

Why is your database reference changing?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[BeeTrees]

Not changing but stop working and giving error message.

 

[SkipVought]

What happens in vagueness, stays in vagueness.

Can you be less vague?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[BeeTrees]

Each time either i have to refresh data file (newly exported) or try any one of the other option. I am also using sqlcmd variable.