I know this is going to be an easy one, I am new to SQL and have not been able to figure it out.
I have SQL 2005 and was able to register the external server extsql.people.extranet.domain.com from SQL Management Studio.
From there, I can query without any problem the "External" DB.
Use External
select * from tblsample

What I am trying to do is a local SP to get info from the External DB but I have not been able to access the DB.
I have tried the following without success:
use
extsql.people.extranet.domain.com.External
select * from tblsample
---------- And
select * from extsql.people.extranet.domain.com.External.tblsamp le

Thanks for the help