Guest User

Untitled

a guest
Aug 12th, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. How to connect to another instance of Sql Server with different version in Sql Server 2008 Stored procedure
  2. create procedure NewTestProc (
  3. @I int,
  4. @userName sysname,
  5. @password sysname
  6. )
  7. as
  8. begin
  9. declare @locallogin sysname
  10. set @locallogin = SUSER_NAME()
  11.  
  12. EXEC master.dbo.sp_addlinkedsrvlogin
  13. @rmtsrvname=N'OTHERSERVER', @useself=N'False',
  14. @locallogin=@locallogin,@rmtuser=@userName,
  15. @rmtpassword=@password
  16. EXEC OTHERSERVER.DestinationDatabase.dbo.StoredProcInOtherDatabase
  17. @OtherParameter = @i
  18. EXEC master.dbo.sp_droplinkedsrvlogin
  19. @rmtsrvname=N'OTHERSERVER',@locallogin=@locallogin
  20. end
  21.  
  22. EXEC master.dbo.sp_serveroption @server=N'OTHERSERVER',
  23. @optname=N'rpc', @optvalue=N'true'
Add Comment
Please, Sign In to add comment