You may get the 'root element is missing' error message if some of the XML files from %localappdata%\Red Gate\SQL Prompt 10 are corrupted.
To fix it, please try the following steps:
1. Uninstall SQL Prompt
2. Copy your style and snippets folder and save in another folder
3. Delete the files in %localappdata% > Red Gate > SQL Prompt 10
4. Reinstall SQL Prompt
5. If necessary, copy the custom style files and custom snippets over to the newly created SQL Prompt 10 folder respectively.
16
-4
Was this article helpful?
6 out of 16 found this helpful
Articles in this section
- Moving snippets to another machine - SQL Prompt
- Error: Windows could not start the Redgate Client service on Local Computer. Error 1067: The process terminated unexpectedly
- SQL Prompt crashing SSMS
- “Access to the path ‘XXXX’ is denied" or "Object reference is not set to instance of an object."
- Root element is missing
- SSMS native IntelliSense doesn't work after SQL Prompt trial expires
- Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=16.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies
- Overlapping SSMS query windows
- Installing/Activating SQL Prompt from the .msi File
- 'Encapsulate As New Stored Procedure' doesn't include variables as parameters