So far I never asked for a review of the QotD before it is going to be published, as this would mean a big effort for Steve or some other...

3 GB Switch is supported for 32 bit editions. It tell operating system to allocate 2 GB RAM to OS and 2 GB RAM to other program such as SQL...

Cool question! Taught me about a new way to execute dynamic SQL.

Thank you Sudhir.

To all who reported troubles: It works perfectly on my instance of SS2005. What messages did you...

Gail,

That did it. The DB log does not hang any longer.

Thanks to you and Satish for your quick and effective help.

Thank you Satish,

Although it does not help me per se, I will try this forum as well. Maybe I can get some solution from there.

Hi again,

No, neither replication nor mirroring is configured for anything on this server. If I look into the mirroring properties of the DB, it states "Diese Datenbank wurde nicht für...

Hi Satish,

Thank you for your prompt reply. Actually I can rule out open transactions as I have restarted all services. This should roll back and close all eventually open transactions.

Got it wrong as well, as I found a third way to interpret the QotD:

We have server ABC and installed two instance on it ABC\First and ABC\Second. we setup the...

Lynn Pettis (11/17/2009)

---

I disagree. To answer a question is more than reading the words and selecting an answer. You have to understand what the question is asking. ...

The question was so clear, you actually could not misinterpret it:

Or to put it...

Hi,

I tried it as well and got exactly the predicted results. You must, however, be aware that result sets ("Date is Null"; "Date is Nu") and the messages ("Option 1:",...

What's wrong with this statement?

Hi,

You may add pictures to your list of reports. (Right click on "Reports", then "Add", and finally "Existing Element". Choose your image file from the file popup and click on...

I always proceed as follows:

1) Change the result set of the SP.

2) Open the report in VS (report designer).

3) Choose the Data tab.

4) Refresh the field list.

5) There are your...

Hi,

The Online Manuals state it quite clearly:

http://msdn.microsoft.com/en-us/library/ms176089.aspx:

char [ ( n ) ]

Fixed-length, non-Unicode character data with a length of n bytes. n must be a value from 1 through...