|
|
Posted by Neil on 05/16/06 02:31
> In its simplest form, you just say:
>
> sp_addlinksedserver 'THATSERVER'
>
> and THATSERVER will refer to a server with that name. However, you
> can also say:
>
> sp_addlinkedserver 'MYSERVERNAME', '', 'SQLOLEDB', 'THATSERVER'
>
So, basically:
sp_addlinkedserver @server = 'MYSERVERNAME', @provider = 'SQLOLEDB',
@datasrc = 'THATSERVER'
I'll give that a shot. Thanks.
Neil
Navigation:
[Reply to this message]
|