Guest User

Untitled

a guest
Feb 16th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. Product Name: ###.###.#.###:####/SRV1
  2.  
  3. Data Source: ###.###.#.###:####/SRV1
  4.  
  5. EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName'
  6. , @srvproduct=N'###.###.#.###:####/SRV1'
  7. , @provider=N'OraOLEDB.Oracle'
  8. , @datasrc=N'###.###.#.###:####/SRV1'
  9.  
  10. EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LinkedServerName'
  11. ,@useself=N'False'
  12. ,@locallogin=NULL
  13. ,@rmtuser=N'OracleUserHere'
  14. ,@rmtpassword='passwordhere'
  15. GO
Add Comment
Please, Sign In to add comment