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)

August 13, 2009 · 1 min · 41 words · kenno

Backup & Restore MS SQL 2000 Database

This is a short note I used at work to back up and restore the a MS SQL 2000 database. I have a database with the name abcengine running on a local SQL Server. I need to back up this datbase to a file, send it over to a remote SQL Server to restore it. There are two ways, which I’ve known, to back up a database. One of them is to use the Enterprise Manager to virsually back up, and another way is to use the Query Analyzer, writing the T-SQL code and run it....

January 15, 2009 · 2 min · 283 words · kenno

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....

May 13, 2008 · 1 min · 192 words · kenno