SQL Kiwi (1/31/2012)
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:
😎 As long as you say it with a positive attitude and maybe a little "I really wish I could, but I just can't figure out how to allow bad data into the database." That will usually get the stakeholders to rethink the request.
Jared
CE - Microsoft