Yea, you need to check out the section on Linked Server in the BOL. It's a really cool feature where you tell SQL Server how to connect to a remote data source (SQL Server, OLEDB, or ODBC). You can then reference the Linked Server in your queries and SQL Server will make the connection.

-Mike