|
|
Posted by Neil on 05/15/06 11:14
After creating a linked server to a remote server, I needed to log in using
sp_addlinkedsrvlogin to get my stored procedure to work. However, I noticed
that after stopping SQL Server and the DTC and then restarting both, that my
stored procedure worked without having to execute sp_addlinkedsrvlogin.
Is the log-in information stored in the machine, such that if SQL Server is
stopped or the server is rebooted, on does not have to execute
sp_addlinkedsrvlogin again? Or is there a point at which one would have to
re-log-in to a linked server?
Thanks.
Navigation:
[Reply to this message]
|