There typically is only one active transaction log per database. Or do you mean number of active transactions?

Is it a named instance?

Installation of a named instance of SQL Server 2000 virtual server on a Windows 2003-based cluster fails (815431)

I tend to do...

Why didn't you restore the .NDF file from the same time frame? Do you have a full SQL Server backup of said database?

I've been through a similar experience. We've considered going to smaller UPSes but they take up rack space and add considerable weight.

Veritas (now owned by Symantec) and PolyServe have solutions that I know of, and I'm sure there are others. I've seen PolyServe's solution demo'ed at PASS last year and it...

You can find Microsoft tested hardware cluster solutions in Microsoft's Windows Server Catalog.

Microsoft: Failover Cluster Solutions

1.) With this hardware setting, would I be able to do a cluster setup for SQL Server. (Active/Active or Active/Passive). Do I need Window 2000 Advanced Server (I think I...

Similar to another post...

CREATE PROC usp_CheckList(
 @parm  varchar(100))
AS

SELECT *
FROM dbo.MyTable
WHERE '%,''' + checkfield + ''',%' LIKE (',' + @parm + ',')
GO

Not a very efficient query, though.

My company has a generic phone number one can call into and if you know the employee's name you can be transferred to the extension. I'm glad I have such...

When you use EXEC or sp_executesql, the code actually executes in a separate SQL batch than the one issuing the EXEC or sp_executesql command. This means a single hash (#)...

It can be. Profiler is basically doing the same thing except normally when folks use profiler they take one of the standard templates. Also, if you're not running profiler on...

The target server memory counters tells you what SQL Server wants to have in order to run efficiently. The total server memory tells you what SQL Server is able to...

You don't have to have profiler running constantly. You do have to have traces running. And yes, there is some performance hit. However, you can specify to only run...

You can with 2000 if you use tracing. That's the audit mechanism. There are trace events corresponding to object creation/deletion.

Because Triangle got it first.

As for the shirt, I'm sure we could spray paint SSC on a t-shirt and mail it to GPF.