Link Tables

I have two databases and one of them contains a table that
I would like to link between the two. I have used the link
table wizard to link a table from a secondary database
with Microsoft Access and was wondering if there is a way
to do this in SQL Server 2KThank you so very much!!!|||Try a View
CREATE VIEW DatabasenameN.Owner.VW_test
AS
SELECT a.V1, a.V2, b.V3 ......
FROM Databasename1.Owner.Table1 a
JOIN Databasename2.Owner.Table2 b on a.Vx = b.Vy
WHERE ......
Hope this Helps

Lingering subscription after disabling Publishing and distribution

Hi,
I have used the 'Disable Publishing and Distribution wizard' to remove all
publications and subscriptions and it went successfully. But why is there a
subscription item listed in the 'Subscriptions' folder under the
'Replication' folder in the SQL enterprise manager in both the publisher
server and the subscriber server? How can I remove it?
Wingman
As you've disabled replication, you can run sp_removedbreplication on each
database that has these remnant replication system tables.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)