Error while loading save querry

Hi @Percy Tisetso Modiselle ,

Thank you for reaching out to the Microsoft Q&A forum.

The error "HRESULT E_FAIL has been returned from a call to a COM component" is a generic error message and typically indicates that an underlying SQL Server tool, COM component, or client application encountered an unexpected failure while attempting to save or load the query.

To help identify the root cause, could you please provide the following details?

1. Which tool are you using when the error occurs (SQL Server Management Studio, Azure Data Studio, Visual Studio, or another application)?
2. What SQL Server version are you connecting to?
3. Does the error occur when:
   • Opening a saved query?
     • Saving a query?
       • Executing a query?
         • Modifying database objects?
         1. Please provide the complete error message and any screenshots if available.
         2. Check whether the issue persists after restarting the application and running it as Administrator.

In the meantime, you can also try:

• Updating to the latest version of SQL Server Management Studio (SSMS).
• Resetting SSMS user settings.
• Saving the query to a different local folder to rule out permissions issues.
• Reviewing the SSMS Activity Log and Windows Event Viewer for additional error details.

Once you provide the additional information, we can help narrow down the exact cause and recommend the appropriate fix.