Thursday, September 08, 2016

Query to delete Old data in emo db

Many times we receive error time out expired while deleting old data in emo module.Here is the query to overcome this.It may take some time to delete depending upon the size of your database.

Before running this query, make sure emobackup database exists. Run the following queries in Query Analyser.If you want to delete the data prior to 01/01/2008. Give the data as that in below mentioned query

Query:

emo..A_FlushData1 '2008-01-01'

emo..A_FlushData2 '2008-01-01'

emo..A_FlushData3 '2008-01-01' 

emo..A_FlushData4 '2008-01-01'