create Linked Table
-
Hi dear,
Can we create a linked table in sql server between to servers.
If no then pls explain why?
from
sufian
-
Not sure what you mean by "linked table".
Can you give a example??
-
As far as I know it's impossible to link tables directly between 2 sql servers (unless you are talking about replication).
One option I've seen that could serve that purpuse (if you only need to select data) would be to create a linked server (BOLS for syntax) linking serverB from serverA. Then in server a you can create a view that has the same name as the table in serverB. Then you can query from that view as if it was a base table.
What exactly are your needs for that linked table?
-
Dear Sufian
Are you posting this as a Question of the Day (QOD), or as an actual problem you have?
If its a QOD, you might want to follow the instructions for submitting questions,
We'd love to give you credit for your own question and answer. To submit a QOD, simply send the question, answers and explanation to articles@sqlservercentral.com
If it's not a QOD, please post to a more appropriate forum.
--------------------
Colt 45 - the original point and click interface
-
Thanx Remi,
But remi as in access we can create linked tables from diffrent database as MS-SQL,Oracle,Sybase,MySql etc.
and the linked table updates as source database updates with data.
As per my knowledge it is not good to execute replication very sec as it will take lot of process / overhead.
But can u please explain why we can't create a linked table. As access and SQL both are microsoft product.
thanx
sufain
------------------------------------------
Mr.Phill ,
thanx ----No comments ------
sufian
-
It's probabely by design. You'd have to ask an Sql engeneering guy to answer why it's not possible. Also another answer would be that sql server is not the same product as ms access and they were not desgined for the same uses. Access is meant to allow anyone to create a small db and access data from anywhere without coding knowledge. Sql server is meant for scalabality and performance and should be used by real programmers.
-
As an update, I have moved this to administration (SQL Server 2k)
-
You can create a linked server which will allow you to query a table on server B from server A. The syntax is in books online and there. There are also a few articles here:
http://www.sqlservercentral.com/columnists/ksonti/anintroductiontolinkedservers.asp
http://www.sqlservercentral.com/columnists/rsharma/linkedservers.asp
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply