• Personally... I would tell them no. We don't truncate data at the database level with SQL Server. Tell them it is not possible and that they simply have to truncate it at the application layer. Tell them SQL Server has these safeguards in place to ensure data integrity.

    Somehow you have to force them to do things the right way. That's my 2 cents anyway...

    Jared
    CE - Microsoft