July 8, 2002 at 9:27 am
I have to databases defined RMATV and RMATV_NEW. Can I do a select on one database from the other. when I try
select *
from RMATV.PICKLIST
I get the error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'RMATV.PICKLIST'.
thanks for any help
Randy
July 8, 2002 at 9:37 am
You are just missing the owner. It goes SERVER.DATABASE.OWNER.OBJECT so in your case it would be:
select *
from RMATV..PICKLIST
or this if the object's owner is dbo:
select *
from RMATV.dbo.PICKLIST
Edited by - Nick Beagley on 07/08/2002 09:37:33 AM
July 8, 2002 at 9:52 am
Of those two its better to always specify the owner.
Andy
July 8, 2002 at 10:26 am
Agree with Andy, specify the owner.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply