Sorry for the delay in answering.

We were also surprised to see what is happening.

Because of the Online Rebuild functionality we sold the customer the Enterprise license.

The most ciritcal table has...

Thanks for your reply.

As mentioned before the online rebuild is not working as expected.

Whenever we do this and there is a transaction which makes an insert into the designated table...

OLDCHAPPY (6/16/2011)

---

mirroring won't help because one database will always be offline in NORECOVERY mode having the transactions applied. you won't be able to do anything with that database. you might...

Does noone has a solution to my problem? 🙁

Hi Jack.

Thanks for your reply.

Yes the column is a proper datetime data type and I am passing the following parameter for the datefield in the where clause:

DELETE FROM <table> WHERE...