accessing db file with multi server

I don't know if this is possible but let's say that we have one main in a
machine and we want to access into that db file in multiple db server.
So that we can reduce the each db server's traffic but accessing same source
of data.
I am not asking about replication but I want to know if this is duable.
Thanx in advanceKim,
No.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"BK Kim" <bkkim@.destinationrx.com> wrote in message
news:eeL%23mbFWDHA.1368@.TK2MSFTNGP11.phx.gbl...
> I don't know if this is possible but let's say that we have one main in a
> machine and we want to access into that db file in multiple db server.
> So that we can reduce the each db server's traffic but accessing same
source
> of data.
> I am not asking about replication but I want to know if this is duable.
> Thanx in advance
>|||your have one server with DB myinfo
you have server to where that db wants access sever one's myinfo
in sql 7.0 use sp_addlinkedserver on the second server. or go thru the
Enterprise manager and add linked server.
"BK Kim" <bkkim@.destinationrx.com> wrote in message
news:eeL#mbFWDHA.1368@.TK2MSFTNGP11.phx.gbl...
> I don't know if this is possible but let's say that we have one main in a
> machine and we want to access into that db file in multiple db server.
> So that we can reduce the each db server's traffic but accessing same
source
> of data.
> I am not asking about replication but I want to know if this is duable.
> Thanx in advance
>