• Well, if you are using either a local login mapped to a remote login or have the 'be made using this security context' radio button checked, the password(s) will be replaced with ####### and you'll need to edit your script. Here's an example:

    EXEC master.dbo.sp_addlinkedserver @server = N'10.5.13.250', @srvproduct=N'10.2.13.250', @provider=N'MSDASQL', @datasrc=N'10.5.13.250'

    /* For security reasons the linked server remote logins password is changed with ######## */

    EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'10.5.13.250',@useself=N'False',@locallogin=NULL,@rmtuser=N'rmtuserl',@rmtpassword='########'

    Regards

    Lempster