Explanation:

The answer is actually unlimited numbers connections,

Wrong explanation

Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and MSDE 2000 allow 32,767 connections to an instance of the...

I see how that would work for you.  In my view, the term 'add-on' wasn't specific enough.

I've read this here before, but I am guilty of reading more into the question.  Of course, rephrasing the question to: What's the easiest way in a query window or...

Will someone please define: software add-on for SQL Server 2000 ?

We have our SQL databases on RAID sets on a SAN.  I assume, therefore, that the disk defragmentation discussion is moot, since files on this hardware are fragmented by design. ...

Now this:

In addition, the Bulk-Logged Recovery model only allows the database to be recovered to the end of a transaction log backup when the log backup contains bulk changes. Point-in-time...

BOL says:

Transaction log backups are used only with the Full and Bulk-Logged Recovery models. For more information, see Using Recovery Models.

From books on-line:

Log files do not contain pages; they contain a series of log records.

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's data,...