Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kmac54321
Starting Member
5 Posts |
 Posted - 2006-03-31 : 14:42:59
|
| I have joined tables in different dbs ([db1].dbo.table join [db2].dbo.table). I would like to know if I can do that with dbs residing on different servers. The servers are in the same server group as shown in enterprise manager. I am trying to do this in Query Analyser. If I can I would do it in a stored procedure. Thanks. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-31 : 14:57:49
|
| Use 4 part naming Convention as [Servername].[db1].dbo.table Also u may need to use sp_addlinkedserver (Read BOL)Srinika |
 |
|
|
kmac54321
Starting Member
5 Posts |
Posted - 2006-03-31 : 15:37:23
|
| I tried to do that - the message I got said:Server '[Server]'is not configured for DATA ACCESS.Any ideas? (and thank you for responding) |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-31 : 22:51:08
|
| Is ur SQL Server Name : 'Server' ?How did u use it ? (write what you exactly used )Srinika |
|
|
|
kmac54321
Starting Member
5 Posts |
Posted - 2006-04-01 : 13:18:36
|
| The server name is VTS_SQL. I typed VTS-SQL.EMPLOYESS.dbo.VetsEmployee which I think represents SERVER.DB.owner.table.QA did not like VTS-SQL unless I enclosed it ina brace which I did like this [VTS-SQL]. That is when I got the Data Access message. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-01 : 21:57:08
|
| did u read about sp_addlinkedserver (in BOL)Srinika |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-01 : 23:32:27
|
| Using sp_addlinkedServer, you need to register that server on your server and then try the syntax which you are trying and it should work for you.If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
kmac54321
Starting Member
5 Posts |
Posted - 2006-04-02 : 10:23:54
|
| I saw that the server was in sysserver so I did not think it needed to be added - but I did not go far enough. The data access was set to 0 so I guess I need sp_serveroption to set it. Thanks to all who responded. |
|
|
|
|
|
|
join tables from dbs on different servers?