Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to connect to another instance of Sql Server with different version in Sql Server 2008 Stored procedure
- create procedure NewTestProc (
- @I int,
- @userName sysname,
- @password sysname
- )
- as
- begin
- declare @locallogin sysname
- set @locallogin = SUSER_NAME()
- EXEC master.dbo.sp_addlinkedsrvlogin
- @rmtsrvname=N'OTHERSERVER', @useself=N'False',
- @locallogin=@locallogin,@rmtuser=@userName,
- @rmtpassword=@password
- EXEC OTHERSERVER.DestinationDatabase.dbo.StoredProcInOtherDatabase
- @OtherParameter = @i
- EXEC master.dbo.sp_droplinkedsrvlogin
- @rmtsrvname=N'OTHERSERVER',@locallogin=@locallogin
- end
- EXEC master.dbo.sp_serveroption @server=N'OTHERSERVER',
- @optname=N'rpc', @optvalue=N'true'
Add Comment
Please, Sign In to add comment