I am one of 'THOSE' that has that tough habit to break. I have learned something new. I really enjoy programming in SQL, and pride myself on Efficient database...

Jeff,

That is an amazing post. Thank you for the detail. I am going to play with some of your suggestions and compare my results. It all makes sense however.

Giles,

Yes I am sure that the data is being propagated from various sources and not at the same time. Additionally in some cases, like the...

Jeff,

Good answer. Concurrency is certainly an issue together with the row locking. I had considered locking however did not give any thought to concurrency issues.

On the other side of the...

Thank you for your help.

Log File from crash:

2006-01-19 12:23:07.81  backup Database log truncated: Database: current1sql.

2006-01-19 12:33:36.73  spid455 The index entry for row ID  was not found in index ID 9, of table 107289775, in

2006-01-19 12:33:36.73  spid455 Error:...

Good evening all. I ran into this problem today as well, SQL 2000.

One person is blaming that a SHRINK LOG was run on that database, and this caused the start...

To add to your project. I would have a primary key if I were you. There are scripts here that will built audit tables for you, including the triggers for...

Ok I am late to the scene, and not sure if my input will be useful to this user, or perhaps others. This is however something that I recently addressed...

I had fixed this code today, sorry just getting time to get back to the Forum here.

I found that sometimes this helps:

        IF @NotThinkingToday = 1

select brain from ass...

If you have an AuditTrail table then you don't need a modified date in your 'live data'.

Your AuditTrail table should be the same as your primary or live table except...

Good morning all. I would like to ask a question that touches on this article (one comment really) and perhaps is a little off topic to the overall discussion.

Without specifying...