Need Idiot proof instructions for deleting old journal entries in RMS

• 11-15-2008 11:50 AM

  kdbush64 Joined on 11-15-2008 Posts 1	Need Idiot proof instructions for deleting old journal entries in RMS Reply Contact  Help!  I am a simple shop keeper.   I am running RMS 1.2.   I would like to delete all old journal entries older than 3 weeks.  My problem is I do not know how to run SQL queries and commands.   Any help would be appreciated.

• 12-03-2008 5:33 AM

  In reply to

  RAFI Joined on 12-03-2008 Posts 5

  Re: Need Idiot proof instructions for deleting old journal entries in RMS Reply Contact RUN Sotre Operation Admistrator Click File -> Connect then you will get a window Enter ur Server name Enter ur user name and password of sql server (if ur using trusted connection then just select the windows authontication) Select ur database and click ok. After the successfull connection u can see the server name and database name on the status bar click the query -> new from menu then you will get the query window Copy and paste the following query to that window DELETE FROM Journal WHERE [Time] < CONVERT(DATETIME, '2008-11-29 16:39:40', 102) you can edit the  date but dont make any changes in query date format should be in yyyy-mm-dd finally you can press F5 or choose RUN from Query menu to run the query. All the best