The question probably should have said that RESTORE VERIFYONLY doesn't write to the msdb.dbo.restorehistory by default. But there is the LOADHISTORY parameter that will make it so.

Thanks, that is good information to have. I was just curious to know if that was the correct answer. 77% had it correct so now I know.

Yes, seems to be some conflicting information in BOL.

You are doing a great job. I love this forum. You have managed to attract a lot of talented people who feel passionate about these topics.

Ever think of recreating a group / committee / review board to review submitted QODs, with the caveat that if there is a lot of response complaining / disagreement...

I don't think this one ranked very high on the rant scale. We didn't even fill up 2 complete pages yet.

Thanks Steve. Actually I am inclined to agree with Markus and would have selected all four had I not consulted BOL.

I was misled by the way BOL is laid out. It would appear from BOL that there are 3 type of Hints, Join Hints, Query Hints and Table Hints....

OK, I understand what you are saying. If my client connects by specifying the IP and Port then it would not use or need the Browser Service. Thanks...

I was just about to make the same point. It seems that Conecting via TCP/IP should be correct also?

cmcklw (11/14/2008)

---

Cliff Jones (11/14/2008)

---

I am not sure why they changed the scripting so that it does not include the 'GO'? It is such a subtle little change that has...

I am not sure why they changed the scripting so that it does not include the 'GO'? It is such a subtle little change that has caused us a...

slange (11/14/2008)

---

I now make it my standard habit that after the declaration of the sp i wrap the entire body in a begin end.

declare myProc() as

begin

end

Once you stub in the...

Iggy (9/23/2008)

---

Since when is QotD about English (grammar/syntax/meaning/whatever it's called)? Not everyone here have English as their native tongue. I'd like to think this site is a worldwide community, not...

With a server side trace you can choose the drive to which the trace goes. One of the benefits of doing that is that it won't fill up the...