Author Topic: Deleting all trial Transactions  (Read 10351 times)

msheed

  • Newbie
  • *
  • Posts: 23
Deleting all trial Transactions
« on: August 27, 2012, 01:11:41 am »
Hello Emre,
How are you??
I have used the dtran.sqlce file to delete the transactions but it didnot work out for me.
Am new to the computing world and they talked about deleting them from sql compact but still i cannot get any success.

I was personally asking if you could only give me an outlined procedure on how i should delete trial transactions when the restaurant is starting to operate seriously??Please i know people have already requested for the same but i tried and failed,Please give me a procedure drawn out,i guess it will help alot on my side.Thank you so much

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Deleting all trial Transactions
« Reply #1 on: August 27, 2012, 07:10:49 pm »
Which database are your using?

msheed

  • Newbie
  • *
  • Posts: 23
Re: Deleting all trial Transactions
« Reply #2 on: August 28, 2012, 12:23:55 am »
Am using sql server 2005.

emre

  • SambaPOS Developer
  • Samba Team
  • Hero Member
  • *****
  • Posts: 1564
Re: Deleting all trial Transactions
« Reply #3 on: August 28, 2012, 05:34:00 am »
install Management Studio for SQL 2005, run MS, login, create a new query, choose "SambaData2" database and paste dtran.sql content in query. Hit F5.