Thanks for your'll advice.

I rebooted the SQLserver last night and was

able to delete at the console. We have RPC problem for a long time and reboot cleared RPC problem....

The error was created when I use:

sp_attach_single_file_db 'heat', 'c:\mssql7\data\heat_data.mdf'

I ran"

dbcc checktable ('systables') and got:

DBCC results for 'sysobjects'.

There are 120 rows in 2 pages for object 'sysobjects'.

My email is gbarr@czn.com,...

Thanks guys. The suggestion by Andy Warren worked. I recreated a new one, deleted the old column and the datetime field is working now.