SQL Server Management Studio
Database diagrams on disconnected devices
If you try to use the database diagram feature in SQL Server Management Studio and the owner of the database is a domain id but you are disconnected from the domain (notebook users!), you’ll get an error like this: “Database diagram support objects cannot be installed because this database does not have a valid owner. [...]
Import using Excel in SSMS fails with “EXCEL” connection manager not recoginized.
Error: The connection type "EXCEL" specified for connection manager … is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. I found one suggestion of reinstalling MDAC (right clicking %windir%\inf\mdac.inf->Install). Needed XP [...]