One possible way to do this would be to add / modify your insert or instead of insert triggers to check for a null value for that column and then call your...

Remember that you need this account for clustering as without your clustering service cannot start your sql service