• hi i performed truncate table in sql server 2005 & i was successful but it just throws an alert not an error as u have mentioned