Hello

my scenario requires 2 databases in one project, and as i read thru documentation, it said that this scenario is best to be implemented with adapter. Also i need to query data using joins between 2 tables in different databases. As i understand, it's not a problem with adapter since it uses full schema name in queries, but do you guys have any information about perfomance of cross-database joins? is there any critical perfomance hits?

thanks in advance

Hi,

You should not have much problem setting up your cross dbs project: simply tick the corresponding catalogs while importing the schema.

Now, about performances, there does not seem to be much overhead for sql server. I've read the following post, which is quite informative:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=db9791d0-dd2d-487b-a372-0b38a4432b95&p=1

Cheers

ok, thank you