SQLKnowItAll (1/31/2012)
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.
Ah! The famous DBA "can't do" attitude :laugh:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi