What version of SQL are you running. 

There is a problem (bug) in 7.0 that would cause this to happen.

After much effort back and forth with MS, they confirmed it a bug.

It is fixed in 2K