Making a Select between two diferent SQL Servers...Urgent please Help

Hi there friend...I'm in a midle of a program(vb.net). and i've got this problem, I've got do compare two tables from two diferent sql servers. Is this possible? How can I do this?

Please, this is really urgent.

Thank you for your attentionLook into Linked Servers in Books Online. Then you can reference another server once it's linked to your SQL Server. HTH|||Tnks, i will do that.

Maintenance Plan Wizard ... No User Databases

A friend is trying to use the Database Maintenance Plans to build maintenance
jobs for her databases. She is using SQL 2005 Ent Ed. Her account is in the
system administrators role. She can back up the databases by writing the SQL
scripts manually. She can also use the object browser to walk through to the
appropriate database base and right-click to back up the database
... but - when she opens the maintenance wizard, there are not any user
defined databases listed there, only the system databases. I am not local
and I have not actually seen her configuration. Has anyone seen anything
like this?
Thanks.
Ann
I just found out that when the databases were imported, they were set to be
SQL 7.0 compatible. The info in BOL updated July 2006 states that
maintenance plans only work with compat level of 80 or higher.
"alw" wrote:

> A friend is trying to use the Database Maintenance Plans to build maintenance
> jobs for her databases. She is using SQL 2005 Ent Ed. Her account is in the
> system administrators role. She can back up the databases by writing the SQL
> scripts manually. She can also use the object browser to walk through to the
> appropriate database base and right-click to back up the database
> ... but - when she opens the maintenance wizard, there are not any user
> defined databases listed there, only the system databases. I am not local
> and I have not actually seen her configuration. Has anyone seen anything
> like this?
> Thanks.
> Ann