I know what you mean, both of mine were up about 4 times last night too. Must be something in the air.

I think the through these negative answer questions in...

"You are trying to audit your SQL Servers to determine what version they are on.

To do this, you're looking for a method to tell the version number of your...

What does amaze me is that as of the time of this posting 35 people think there is such a thing as "Windows Application Application Log".

Well at least questions...

Thank you...Learn something new everyday...Thats what these questions and forums are for.

I thought exactly the same thing. I did not think you could use MSDE in a production environment.

Anyone know the answer as to this MSDE question.

Also there is explanation in...

When I indicated not updated as expected, from a Syntax Point of view, looking at the update query (which is what one does in QC) it indicates:

UPDATE Invoice

SET PaidFg =...

The answer is correct! The explainion given is not correct as it states

"[...] it will still run a partial update of the table. It will not change the PaidFg...

I agree with you as well, I think both views of this question are correct.

Having with where, without where, with group by, without group by are all valid options....

From BOL:

The HAVING clause sets conditions on the GROUP BY clause similar to the way WHERE interacts with SELECT. The WHERE search condition is applied before the grouping operation occurs;...

From:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_77g3.asp

Looking at the default values from the table at the bottom of this artical, I would take the correct answer as #3 "TCP/IP, Local Named Pipes" and I see...