Hmm. Well, now I am not sure that that is possible either. BOL implies that you can use OPENROWSET like that, but every reference that it makes to...

Use OPENROWSET and Bulk export the Logging data as XML?

To the best of my knowledge, Hyperthreading is not recommended for SQL Server.

Oops, I got that wrong. Try it like this:

BEGIN TRAN Logging

...(write to log table)

COMMIT TRAN Logging

Hmm, looking at BOL, I am really doubtful that this will...

Ah yes, the notorious "Undetectable BCP Deadlock". The usual fix involves restructuring the transaction so that you can do your logging outside of the transaction boundaries. If you...

Glad I could help.

First, It is not at all clear to me what he is actually trying to do, that is not a valid query that is listed, and it is impossible to...

Where are you going to get your list of holidays from?

If you are not using holidays, then your specific problem is dead easy: 10 business days is always exactly...

I do not see anyplace in SSMS where this would be a valid entry. Where/in what facility are you entering the connection setting?

*whew!* Glad I could help. 🙂

OK, actually it looks like everything is working now. The ALTER TABLE Event messages are in the queue.

What is reading the queue and what makes you say...

Actually, I did think of one other thing, try this command:

Select * from dbo.NotifyQueue

And let us know what it shows.

Huh. Well, I cannot see anything wrong with it now. Sorry, to say Manu, but I am out of ideas.

OK, I will try to step forward through it then.

Execute these commands and post their output here, please:

Select * from sys.databases Where name = 'Logging_Demo'

Select * from sys.transmission_queue

select * from...

jim.powers (9/2/2008)

---

One thing I don't quite understand is why these SSDs are using flash type memory for server solutions (due to its limited life span)? For laptops, absolutely, they need...