Hello,

 

 

You can create one Stored procedure or trigger which will execute on mid night and delete all messages which is not used by the current login users.

 

regards,

 

 

From

Nimit Patel