MS SQL: Reset identity seed
Occasionally, I need to reset the value of the identity column in MS SQL database. I keep forgetting how to do this, and have to search all the time. So here is a note to myself: DBCC CHECKIDENT (TableName, RESEED, 0)
Database
SQL Setup error on Vista: SQL Server Setup Failed to compile MOF
I was attempting to install MS SQL Server 2005 Express edition without success on a computer run Windows Vista Business. There was an error message mentioned “…failed to compile the Managed Object Format (MOF)…” I’ve tried about five times with various solutions; still it didn’t fix the problem. As always, I found a working solution when I was about to give up on this installation. The problem was that the WMI repository was corrupted. There are two ways to fix this: one is to reinstall the WMI, and alternatively you can repair it instead. ...