Viewing 15 posts - 1 through 15 (of 36 total)
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
June 5, 2008 at 6:32 am
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...
May 12, 2008 at 7:24 am
I agree that saying
mssqlsystemresource.mdf should not be considered Resource but MSSQLSystemResource
can probably be considered splitting hairs. :hehe:
My BOL talks about 5 system databases as well.
Cheers!
Jeff
May 8, 2008 at 8:48 am
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...
May 8, 2008 at 6:14 am
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...
April 29, 2008 at 6:33 am
Correct....so to quote Steve earlier
The process is *not* re-entrant.
Cheers
April 11, 2008 at 12:24 pm
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...
April 11, 2008 at 9:46 am
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
April 9, 2008 at 6:40 am
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...
April 4, 2008 at 6:18 am
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...
April 3, 2008 at 7:35 am
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...
April 3, 2008 at 7:12 am
Viewing 15 posts - 1 through 15 (of 36 total)