Posted by Jens on 10/01/47 11:39

Sure for different databases on the same server you can use the
threepart name: Database.Owner.ObjectName (e.g. SELECT * FROM
somedatabase.dbo.SomeTable)

For database on a different server you have to use a linekd server
within the fourpart name: linkedServername.Database.Owner.ObjectName
(e.g. SELECT * FROM linkedServername.Database.Owner.ObjectName )

HTH, jens Suessmeyer.

• Next in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Prev in forum: interdatabase trigger possible??
• Thread view: Re: interdatabase trigger possible??

[Reply to this message]