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...:-)

You cannot use that syntax: the object to query cannot be a parameter.

You could use dynamic sql:

DECLARE @sql nvarchar(max)

SET @sql = 'SELECT * FROM ['+ @dbname +'].Table1'

EXEC sp_executesql @sql

Anyway you...