ERRMSG: Sql Server Management Studio gives the error message "Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)"

Problem: Sql Server Management Studio  gives the error message "Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)"

In order to resolve this do the following:
-Click "View" -> "Object Explorer Details".
-Double click on the Databases folder.
-Right-click on the column headings area and un-check the "Collation" option.

In order for this to have an effect you must then refresh the database list by right-clicking on the "Databases" list in Object Explorer on the left and selecting refresh. You should now be able to browse the database list successfully.

  • 236 Users Found This Useful
Was this answer helpful?

Related Articles

FAQ: Why is the design feature greyed out in Enterprise Manager?

The reason why you would not be able to use the design feature (greyed out), is because some...

FAQ: My database transaction log is too large

If your database is getting too large, it is most likely because of the transaction log file.If...

FAQ: What can I use to connect to my MS-SQL database?

You can use any third party MS-SQL client like:-SQL Server Management Studio express (microsoft...

PRB: Cannot connect to SQL 2008 or 2012 using Enterprise Manager

Enterprise Manager is not compatible with SQL 2008 or 2012 and will therefore not allow you to...