Problem is that on one server you will only need one connection and,
given you have permission to both databases, you can query either, at
will, with only the three-part naming convention:

<database_name>.<schema>.<object_name>

Once you've installed one of the databases on another server, you will
need to create a linked-server on one of them to the other and will need
to refer to objects there with the four-part naming convention:

<linked-server_name>.<database_name>.<schema>.<object_name>

Also, linked-server security is always troublesome if you want to lock
it down.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Jean-Marc Ledgister
[mailto:mssqldba-ezmlmshield-x12540282.[Email address protected]
Sent: Saturday, August 28, 2004 10:56 PM
To: LazyDBA Discussion
Subject: re:using to databases 1 server

I want to be able to use 2 databases I has user inform the other has
payroll they are both on the same server and I want to be able to search
for name in one and add pay info in the other is this possible reason
for this is at a given time later they will be on 2 separate servers



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page