I came across an annoying glitch in an instance SQL Management studio express today.
The install was with SQL2005 Express, and windows 2003 server.
When i expand some child nodes eg: list of databases, i got a persistent error that would require a second retry to expand the nodes.
The error was :
TITLE: Microsoft SQL Server Management Studio
------------------------------
Unable to cast COM object of type 'System.__ComObject'
to interface type
'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'.
This operation failed because the QueryInterface call
on the COM component for the interface with IID
'{6D5140C1-7436-11CE-8034-00AA006009FA}'
failed due to the following error: No such interface
supported (Exception from HRESULT: 0x80004002
(E_NOINTERFACE)). (Microsoft.VisualStudio.OLE.Interop)
To solve this i found registering a dll worked for me...
try entering this at a command prompt
----------------------------
regsvr32 actxprxy.dll
----------------------------
...wish i tried this days ago now it cut my click count in half :)