Oh wow! I wasn't aware of that. Sorry.

I haven't used the thing in years, or needed one. I guess that's a good thing.

Another option, not necessarily a good one, is to add a version column to your PK and then only do inserts. You can then do one of two things. Insert...

Or whoever...

Red Gate also offers a log reading product. It works pretty well.

Gail's right though, while something like Red Gate's Log Explorer can help, auditing is a more intentional act...

Just a side note, a hash match isn't necessarily a bad thing. It can be the best way to retrieve the data, depending on the data involved.

Very little code to work with here, but have you looked at the ROW_NUMBER function in Books Online? I think that might help you do what you want.

If not, post...

At this point, you're totally violating the idea of a primary key. You may have a unique...

Many happy returns of the day, Steve.

For myself, a good bottle of single malt scotch is all I need for happy birthday... or a happy any other day for that...

matt stockham (9/11/2008)

---

Grant Fritchey (9/8/2008)

---

Our servers only restart once a year as part of the annual power down (although, some of them do, occasionally get rebooted for other reasons :sick:...

No. I'm not getting this one. Sorry. I've only done about four installs so far (not counting CTP's), but no issues at all... So far... knock wood.

I'll shut up now and go and stand in the corner.

Without a doubt it's going to be better than reading twice every time, definately. I've had to fix that problem WAY to often myself. I was just curious how many...

Yeah, you can do that without recompiles. Does it cause excessive scans or reads in the table since it's searching for a PK that doesn't exist every single time?

It's not a huge deal to do this, but it will result in recompiles on the procedure since the execution plan for an UPDATE and one for an INSERT are...

TRY/CATCH won't help performance, but it will make your code easier to write & maintain.

Can you post an execution plan? If possible, the actual execution plan not the estimated one.