Linked Servers

cgmojoco · Post by **cgmojoco** » Wed 30 Nov 2011 02:11

Do I have to do anything special to get SQL Complete to work with linked servers? Is it supposed to work out of the box (it isn't for me).

I am not sure the linked server is being recognized as the server type that might be required by SQL complete...(we are using a SalesForceBackend---I'm not sure what the db platform is for this datbase).

Is there any chance that future development might include support of all database types?

alexa · Post by **alexa** » Thu 01 Dec 2011 16:05

Please note that linked servers are supported only in the Standard edition of dbForge SQL Complete. Before starting to use a linked server you have to set it up as follows:

exec sp_serveroption @server = 'server_name' , @optname = 'DATA ACCESS' , @optvalue = 'TRUE'

where 'server_name' - your server's name.