You may see the 'root element is missing' error if one of the XML files in %localappdata%\Red Gate\SQL Prompt 11 has become corrupted.
To fix it, follow these steps:
- Open File Explorer and paste
%localappdata%\Red Gate\SQL Prompt 11into the address bar. - If you've created any custom formatting styles or snippets, copy the Styles and Snippets folders to a safe location so you don't lose them.
- Uninstall SQL Prompt.
- Delete the contents of
%localappdata%\Red Gate\SQL Prompt 11. - Reinstall SQL Prompt.
- If you backed up custom styles or snippets in step 2, copy them back into the newly created Styles and Snippets folders.
Note: if you don't see a Styles folder, that just means you haven't created a custom formatting style, so there's nothing to back up there. You can skip straight to uninstalling.
38
-12
Was this article helpful?
13 out of 38 found this helpful
Articles in this section
- Entra ID MFA Authentication
- SQL Prompt installation issues with the SSMS 22 Import Settings flow
- Prompt AI failed to log in
- Unable to access SQL Prompt AI features
- SQL History is blank or greyed out
- SQL Prompt missing from toolbar after installation
- Add SQL History to a shared folder
- Error: Something went wrong while signing in. Authentication failed.
- Installing and running SQL Prompt
- SSMS Tab Management
What and where is the “style and snippets” folder?