Posted by Captain Nemo on 01/24/06 16:46

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:LBqBf.4368$ft2.109590@news20.bellglobal.com...
> The OP said the two DB's were on the same server. Therefore, 3-part
naming
> is sufficient.
>
> --
> Tom

It sure is! I've just tried it out. Where I went wrong was thinking that
2-part naming would do it (omitting the 'dbo').

Thanks, Tom

• Next in forum: Re: Joining tables in different databases
• Prev in forum: Commit Transaction Gets Deleted - Unable to save SP
• Thread view: Re: Joining tables in different databases

[Reply to this message]