- Databases with full-text searching enabled can’t be restored to root directories on drives for some reason, so they’re in D:\Data and the log is in F:\Logs. Unfortunately the error message wasn’t in any way relevant, so it took some digging to find this.
- I had to manually create an FTData directory on C: and assign rights to the SQL Service account.
Resources for this solution:
Simons Sql Blog
Martin Welch Consulting
Share on Facebook
1. Create an advanced find view of the records you want to export to Excel for example: Active Contacts.
2. Click Excel on the toolbar and select Dynamic Worksheet option
3. Open the excel workbook and enable Data Connection
4. On the excel workbook, right click and select ‘Edit Query’
5. If the pop-up window “The query cannot be edited by the Query Wizard”, opens,click OK. Now you will see the Microsoft Query window.
6. From the Microsoft Query toolbar, click View and select SQL. A new pop-up Windows showing the actual SQL statement appears.
7. Remove the part of the query that states ‘Top 10000′ from the SQL statement and click OK to exit the SQL statement window
8. From the Microsoft Query window toolbar, click File and select Return Data to Microsoft Office Excel
9. Refresh your excel worksheet if auto-refresh is not enabled and you should see all data from the select CRM view now
Sourced From: CRMConsult.info
Share on Facebook