CRM 4.0 - Delete Contract record

[Tim]

Does anyone know how to delete a CRM 4.0 contract record (with status set to
'Canceled')?

I already tried using a Workflow to set the status of the contract record to
'Draft'. But, no luck it didn't work. It seems, the Microsoft CRM devloper
team hardcoded a restriction so that users (with full permission) can not
delete Contract records with status set to "Cancel". 'Not sure the business
logic behind this decision. Any help or suggestions would be greatly
appreciated.

[Bilal Kassassir]

Dear Tim,

The delete record option does not exist in the CRM 4.0 as a straightforward
resolution, however you can acomplish this by using a technical procedure on
the SQL Server, "Kindly note that we do not recommend doing this in
Microsoft" you should make a full backup of your database.

To do this, get the GUID of the contract from the form URL (best way is by
hitting F11 in the Web Client), and then find that contract in the
contractbase table. Update the StateCode to 0.

Then open the contract again in the web client and you should be able to
delete it.
Again, this is UNSUPPORTED by Microsoft, kindly be carefull

Post by Tim
Does anyone know how to delete a CRM 4.0 contract record (with status set to
'Canceled')?
I already tried using a Workflow to set the status of the contract record to
'Draft'. But, no luck it didn't work. It seems, the Microsoft CRM devloper
team hardcoded a restriction so that users (with full permission) can not
delete Contract records with status set to "Cancel". 'Not sure the business
logic behind this decision. Any help or suggestions would be greatly
appreciated.