This is one of those things that's fine to start off with, but if everyone started installing stuff in non-default locations then the virus writers would very quickly realise that...

Interesting point there, vk-kirov. I guess that means that the default type for NULL is int--but in that case, there's not really any such thing as an "untyped NULL" and...

It might be because you're on a 64-bit system and it's a 32-bit DLL--don't have any direct experience with the DLL in question, though. Although, haven't Microsoft said that support...

RD Francis (11/9/2010)

The problem I run into is that DBCC SHRINKFILE on Log files doesn't seem to work in a particularly straightforward fashion. As often as not, I ask...

sjimmo (11/9/2010)

A checkpoint occurs regularly in SQL Server, regardless of the recovery mode.

.

.

.

Additionally, you can read more in BOL or at http://msdn.microsoft.com/en-us/library/ccdfc689-ad4e-44c0-83f7-0f2cfcfb6406.aspx as well as many other web sites on...

GilaMonster (11/9/2010)

---

Log backups are not necessary (and won't run) in simple recovery, which George indicated...

I would just stop shrinking them for the moment, and make sure you have regular backups so they don't keep growing out of control.

george25 (11/9/2010)

---

I have quite a few very large databases and, like Giles above, I need to shrink the log files after large amounts of data are imported into the databases....

Hugo Kornelis (11/9/2010)

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this...

He didn't...

honza.mf (11/5/2010)

---

Most of complainers: The problem is not dd/mm/yyyy against mm/dd/yyyy as both combinations are inserted (First of July and Seventh of January).

Problem is in yyyy/dd/mm against yyyy/mm/dd. And...

I knew when I saw it that this question was going to rely on a particular date format being the default...surely that sort of thing should be checked before they're...

We have a log shipping job that runs every 15 minutes, and while the job itself didn't seem to be affected by the change of time, the alerts associated with...

What user account is the actual SQL Server service running under on the machine that works compared to the machine that doesn't?

Thinking about it, you probably only need the Browser service running if you have multiple SQL instances on the same machine. Still, glad you've got it going!