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 -
Example from Toad:
@server = N'ICMS',
@optname = N'rpc out'
, @optvalue = N'False';
Example from SSMS 2008 R2:
, @optname=N'collation compatible' -- missing
Status: Enhancement request was submitted for future release.