One update: Consider that MSSQL won't allow a "truncate table <synonym>"...You'll need a work-around stored proc.