exec sp_droplinkedsrvlogin @rmtsrvname=N'x.x.x.x',@locallogin=N'sa'
exec sp_dropserver 'x.x.x.x'
EXEC master.dbo.sp_addlinkedserver @server = N'x.x.x.x', @srvproduct=N'SQL Server'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'x.x.x.x',@useself=N'False',@locallogin=N'sa',@rmtuser=N'sa',@rmtpassword='password'
No hay comentarios:
Publicar un comentario