Devart Forums

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?

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.