Do you see the server you need in the output from sp_linkedserver?

If one has already been created, try something like:

select name from [YourServer].[Master].[sys].[databases]

You may already be set up and...

Try this:

select

LinkedSrvName = case

when ll.server_id = 0 and ll.local_principal_id = 0 and ll.uses_self_credential = 1 then 'Undefined'

else ss.name end,

LocalName = case

when spn.name is null then 'Undefined Login'...

Once it's set up it'll be there until someone deletes it.

You may need to have someone create the Linked Server initially if you don't have rights to do this, but a Linked Server can be customized to only allow specific...

Yes, very possible.

Take a look at Linked Servers:

http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms190479(SQL.90).aspx