How do i delete transaction history for sql server


I know there is a dtran script for sql compact users. is there something similar for sql server?

i am using sambapos v3



This is the script we use to delete transactions
delete (449 Bytes)

hope this helps!!!


1 Like

Thanks gerlandog!!
I will try it


how would i use this script? do i need to add it somewhere to sambapos or sql server etc ?

please could you explain in a bit more detail on how to do so, thank you very much

Paste the script into a new query window in MS SQL Server Management Studio, and execute it.

WARNING: this action deletes all transactional data and is non-reversable, so make a backup of your DB if you are unsure.