How do i delete transaction history for sql server

Version 4 V4 Question
1

Hi,

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

i am using sambapos v3

Thanks

Jamil

2

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

hope this helps!!!

g.

1 Like
3

Thanks gerlandog!!
I will try it

4

@gerlandog

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

5

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.

2 Likes