servers

hello,
is it possible to use windows authentication to link two sql servers? or is
it possible only with a valid sql server login?
thanks!You can use the following to create a linked server definition that will
allow Windows Authenticated users to logon to linked server.
exec sp_addlinkedserver N'TEST2'
sp_addlinkedsrvlogin 'test2',
@.useself = 'true'
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:E05D0DC8-597A-4986-94C3-50BCBC75228D@.microsoft.com...
> hello,
> is it possible to use windows authentication to link two sql servers? or
is it possible only with a valid sql server login?
> thanks!
>