• forceman29 (4/24/2013)


    EXEC master.dbo.sp_addlinkedsrvlogin

    --@rmtsrvname = N'ServerB',

    --@locallogin = NULL ,

    --@useself = N'False',

    --@rmtuser = N'UserB',

    --@rmtpassword = N'password'

    --Go

    Just uncomment it and run it again :hehe: ?

    EXEC master.dbo.sp_addlinkedsrvlogin

    @rmtsrvname = N'ServerB',

    @locallogin = NULL ,

    @useself = N'False',

    @rmtuser = N'UserB',

    @rmtpassword = N'password'

    Go

    Hope I'm not missing the point...

    Greetz
    Query Shepherd