View Single Post
  #3 (permalink)  
Old March 1st, 2006, 05:47 AM
Gert Gert is offline
Authorized User
 
Join Date: Jun 2003
Location: , , Norway.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is no problem selecting across databases in 2000, you just prefix the tablename with database-name and owner-name like this:

Select * from [databasename].[Ownername].[tablename]

If you need to select from another physical server, you could set up a linked server and then do the select like this:

Select * from [LinkedServerName].[databasename].[Ownername].[tablename]


Gert

Reply With Quote