Linking tables between two SQL Server databases 1

[Guggly]

Hi! How can I link a table from one SQL Server database into another? I know that I can get a read-only view doing something like this:

SELECT     *
FROM         OTHERDATABASE.dbo.TABLE

But, I'm hoping for something that shows up as a table and with write access. Is there any way to do this?

Thanks! -- Mike

 

[mrdenny]

You can insert or update a table in another database on the server as long as the person has permissons to perform that action on that table in that other database.

/*Update Example*/
update OtherDatabase.dbo.Table
set Col1 = 'SomethingElse'
where Col1 = 'Something'

/*Insert Example*/
insert into OtherDatabase.dbo.Table
(Col1, Col3)
select Col2, Col3
From Table
wehre Col5 = 'Value'

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Guggly]

Interesting, so I guess I can't really do a link to have an external table show up in the grid, like is possible with Access, right?

Thanks for your help! -- Mike

 

[mrdenny]

Correct. The grid to create queries is very limited, and doesn't know how to handel tables in other databases or on other servers. Those queries you have to code by hand.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Guggly]

Well, guess I'll have to learn to live with that . Thanks! -- Mike

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)