I was attempting to make a Linked server connection to an Oracle system. I used Toad-SS 5.6 to create same and then script it out. I also used SSMS 2008 R2, which came with more script out options.
I am not sure if the Toad-SS 5.6 linked server script creation goes far enough. Things that are missing from Toad-SS 5.6 are indented and marked with "a -
missing" comment.
Example from Toad:
EXEC [msdb].[dbo].[sp_serveroption]
@server = N'ICMS',
@optname = N'rpc out'
, @optvalue = N'False';
Example from SSMS 2008 R2:
EXEC master.dbo.sp_serveroption
@server=N'ICMS'
, @optname=N'collation compatible' -- missing
, @optvalue=N'false'
Workaround:
None
Status: Enhancement request was submitted for future release.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center