RE: Procedures and functions with cross-database dependencies

SSC Guru

Points: 323507

July 3, 2014 at 11:58 am

on the same server, i believe it's no problem; every query eventually gets resolved to all objects to thee part naming conventions...database.schema.object;

I have a system I babysit that we recently migrated to use Synonyms for the three part objects, to make it easier to build development vs QA vs production instances.

you can look at the execution plans of those kinds of multi database operations, there's nothing different than when all the objects are in the same database.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!