Linked Server - Change of Password

Hi,
If the password changes on a remote source, is there a way of changing the p
assword for the linked server to the remote source via a stored procedure (o
utside of the gui)? Or does the linked server login need to be dropped and
recreated? How does EM do
it in the gui?
Thanks
JerryYou can do it with the sp_addlinkedsrvlogin store procedure like so:
exec sp_addlinkedsrvlogin@.rmtsrvname = 'yourrmtserver',
@.locallogin = 'your local login',
@.rmtuser = 'remote login',
@.rmtpassword = 'new password'
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jerry" <anonymous@.discussions.microsoft.com> wrote in message
news:15134043-AF75-4440-96DD-A3A39747C44D@.microsoft.com...
> Hi,
> If the password changes on a remote source, is there a way of changing the
password for the linked server to the remote source via a stored procedure
(outside of the gui)? Or does the linked server login need to be dropped
and recreated? How does EM do it in the gui?
> Thanks
> Jerry