The followoing solution is for SQL2005 only. It works for read, write and stored procedure calls:

1.

select *

from Subscription.dbo.subscriber

2.

create synonym syn_subscriber

for Subscription.dbo.subscriber

go

3.

select * from syn_subscriber

4.

--move Subscription db to another...