Category: SQL Server Management Studio

Setting SQL Server ROWGUIDCOL property on [uniqueidentifier] (GUID) columns

I’ve been converted – I now use GUID (UNIQUEIDENTIFIERS) instead of INT for most database tables’ primary key.  If there is only going to be 100 or less rows, I don’t bother but most everything else I feel justifies the extra bytes of GUID. It ensures the key is unique which greatly simplifies merging data in the future. A...

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. To continue, first use...

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%infmdac.inf->Install). Needed XP CD handy.Still, the problem persisted....