Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Product Name: ###.###.#.###:####/SRV1
- Data Source: ###.###.#.###:####/SRV1
- EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName'
- , @srvproduct=N'###.###.#.###:####/SRV1'
- , @provider=N'OraOLEDB.Oracle'
- , @datasrc=N'###.###.#.###:####/SRV1'
- EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LinkedServerName'
- ,@useself=N'False'
- ,@locallogin=NULL
- ,@rmtuser=N'OracleUserHere'
- ,@rmtpassword='passwordhere'
- GO
Add Comment
Please, Sign In to add comment