When a table's primary field is to auto increment with a seed and you are deleting the records from the table. Now you need to reset the primary field value to 1. The code given below is useful.
 

   1: DBCC CHECKIDENT (tblName, RESEED, 0)

When dealing with MS SQL (not MYSQL) I’ve seen this error message before, but found very little help on it out there.

The log file for database db_name is full. Back up the transaction log for the database to free up some log space.

Within the MS SQL Query Analyzer, do this:
 

   1: backup log db_name with truncate_only 

   2: go 

   3: dbcc shrinkfile (db_name_log,0) 

   4: go

If anything, this post will be useful for me in the future when one of my MS SQL databases coughs up the error again.