Nice. Very humorous.

😛

Whereas I can agree with the wording change from 'same' to 'identical', I thought it was obvious what this question was testing.

Good question.

Thanks

-Jeff

Currently filestream is not enabled by default...to enable it you must use:

exec [sp_filestream_configure] @enable = 3;

Then to see this value..which is what I think the question is getting at:

"Enabled for...

I agree that saying

can probably be considered splitting hairs. :hehe:

My BOL talks about 5 system databases as well.

Cheers!

Jeff

I can see the debate over this question, however, I'm going to side with this statement:

"The physical file name of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf."

It's my opinion...

The question was only concerned with 3 triggers. Setting the order the way the answer states would work. As for using the solution with more than 3 triggers, keep in...

Agreed, that's why I didn't quote that part. 😉

Correct....so to quote Steve earlier

Cheers

This sounds like the debate over 'enabled' in the QotD earlier in the month

http://www.sqlservercentral.com/Forums/Topic478219-1242-1.aspx

To use the saying from that thread by Steve Jones, it sounds like we are splitting hairs...

Good question.

I agree with Gsquared. Nice analogy btw. 😀

I thought the QotD was an interesting topic. I would also like to thank Hugo for his in-depth explanation. Points or not, I learned something new.

Cheers

I can understand looking at the QotD as a puzzle sometimes and not always from a 'best practices' perspective.

Good point Steve.

Vishal,

Are you just quoting Kenneth? I ask because you have copy/pasted most of his post.

Please scroll up to refer to the other posts on this topic. Just setting the...

Thanks Steve. I just answered and it's working correctly now.

Where I agree on the idea of a review panel, I still learn new things even if the QotD answer or...

Hi Steph,

Let's start with Reconfigure. The options we are setting here can be configured to be turned on. For example. If you execute:

sp_configure 'show advanced options', 1;

Then execute sp_configure you...