Data loss in retrieval of data from SQL table, while the table is being updated

Question

Hi guys,
       I have condition in SQL. I will be updating an sql table with a 10000 records for a second

I am working in a tracker tool , which updates a sql table whenever it listens to an event . Then I will be tracking the changes happened. If a 1000s of changes happens , my tool updates the table in 30 secs (waiting for the event to occur), in between the 30 secs (say at 15 th sec) if I retrieve data from the table, it shows only records less than 1000.

Now I want the process to wait for all updation to be happened on the table and then retrieve 1000 record completely.

---

If a post answers your question, please click Mark As Answer on that post and Mark as Helpful. Happy Coding...

Answer 1

Hi guys,
       I have condition in SQL. I will be updating an sql table with a 10000 records for a second

I am working in a tracker tool , which updates a sql table whenever it listens to an event . Then I will be tracking the changes happened. If a 1000s of changes happens , my tool updates the table in 30 secs (waiting for the event to occur), in between the 30 secs (say at 15 th sec) if I retrieve data from the table, it shows only records less than 1000.

Now I want the process to wait for all updation to be happened on the table and then retrieve 1000 record completely.

---

If a post answers your question, please click Mark As Answer on that post and Mark as Helpful. Happy Coding...

Answer 2

hi,

If I understand your question well, you may need to change your transaction isolation level to the proper level (serializable, etc). If you can post some sample data that may help us to understand your problem better.

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me

Answer 3

duplicate thread: http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/3ade5a5a-6f09-481e-883b-3e3d56dbafc8

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me