How to: Enable ‘Ad Hoc Distributed Queries’ in SQL Server 2008
The other day I did some testing of UC Logic iSync – 3rd party utility for Auotonomy WorkSite which is intended for synchronizing of metadata across libraries. It turned out that iSync requires ‘Ad Hoc Distributed Queries’ SQL server feature enabled to work properly (which was indicaed in iSyncLog available through Event Viewer) which was not enabled in … How to: Enable ‘Ad Hoc Distributed Queries’ in SQL Server 2008