Great idea, Gail.

I never have thought about that!

The main point, however, is that the piece of code (stored procedure, application code etc...) that requested the transaction to start is responsible...

Simply move your logging statement out of the transaction.

BEGIN TRANSACTION

BEGIN TRY

-- Do something here

-- ...

COMMIT

END TRY

BEGIN CATCH

...

Roust_m (10/12/2009)

---

My data is pretty static, so I am not worried about dirty reads and other evils of (nolock), but want to use it to my advantage.

So, back...

RBarryYoung (10/10/2009)

---

Heh. I've been playing this one close to the vest until I had something that I could publish. But I did partly give it away by using...

GSquared (10/12/2009)

---

Gianluca Sartori (10/9/2009)

---

I had a hot discussion with Joe Celko some days ago about the quirky update.

He doesn't seem to like it.

I told him I use the quirky update...

I've been a...

I'm not worried about that, nor I think Olgi...

Not so impossible, indeed:

http://www.google.it/search?q=olgi+sql+server

For me it's the second hit.

:hehe:

EUR or USD?

And, don't forget, the 2 cents are definitely mine...:-D

I had a hot discussion with Joe Celko some days ago about the quirky update.

He doesn't seem to like it.

I told him I use the quirky update expecting it to...

ItalianOlgi (10/8/2009)

---

Gianluca Sartori (10/8/2009)

---

Just pray that your employer doesn't come across this thread.

Good luck.

BTW, I will remember your name and never help you in these forums, because I don't think...

It's quite frurstrating that the only other Italian person I ever found on these forums is such a fool.

I don't think he's in Italy. It's quite unlikely to...

Completely different subject: there's a lot of spam posts with wierd attachments.

I think somebody has mistaken SSC for an online hard-disk...:-)