I beleive the answer is incorrect. Bulk logged also supports PIT recovery, with a caveat. From BOL..."If the log backup contains bulk-logged changes, point-in-time recovery is not allowed. Attempting to...

Thanks Peter.

That is my assumption and understanding also, and I appreciate the confirmation. Do you know of any good documentation on this?

Also, I ran a trace on each method,...

Thank you Gordon, but that is the list for DTC. I am looking for the same enumeration for the Transaction Log, event 54.

Terry

It usually gives that message because you don't have enough available memory at the time of install. Ignore the message, if you can, and run the install.

^{From BOL:}

³SCC will warn...

Agreed this is not very clear. I think QOD is a very popular feature. Perhaps a little more effort could be given to reviewing the questions prior to release?

Terry

Points for D please. Cut and paste the code (change Bob to a valid user) and see for yourself.

Number 4 "Create a DDL trigger on all database scoped events" would also do the trick, so it should also be considered correct though excessive.

Terry

Thank you Mike.

It is my understanding that intraquery paralellism is available on both editions also. But MS has scared management here with a verbal commnents. Do you have any documentation...

Only when the SPAM filter gets it. And that is random but about 2 times a week.

Terry

Congratulations!

Great work, great site, and great community!

Terry

try this...the first line tells which node is active

Declare

@CMD varchar(4000),@Server_Name varchar(100)

Set

It's not there.

When you create a DTS and then schedule it from the DTS interface, it is executed in the resulting job step by referencing the GUID of the DTS. Each new...

In 2005 use certificates. The data is encytped when writted to the column, and decrypted when read. Very nice.

Terry

SQLAgentUserRole  or SQLAgentReaderRole  will work per the source referenced in the QOD.