Tag Archive | "Management studio 2008"


Management studio 2008 issues

After you connected to a SQL server 2005 or 2000 database using management studio 2008 and then trying to expanding the database list you might get error such as "Failed to retrieve data for this request (Microsoft.Sqlserver.Management.Sdk.Sfc)"

It’s quite common, you need to follow the below steps to fix it:

Go to your Management studio -> click View -> Object Explorer Details -> open Databases -> click the header columns and uncheck Collation.

After it’s done, close your SSMS and try to connect to your database again and it will be working properly.


Posted in SQL ServerComments (0)