Yeah, I got about the same usage as well, a few hundred MB, AFTER the install was complete.  I left off the BI Studio to ensure I was well under the...

It is an older server, originally windows 2000, since upgraded to 2003.  When this one was provisioned 4 GB was our standard OS partition size, and everything else was installed...

Oops... it is in the readme.  sigh.

2.5.26 SQL Server 2005 Setup Requires 1.6 GB of Disk Space on the System Drive

During installation of SQL Server 2005, Windows Installer creates temporary...

Hey, 

Interesting KB article, but this is not a named instance.  It does have an alias set up pointing . to . on the default TCP port (which I wouldn't...

That's the maddening part.  The service doesn't fail.  None of the clustered resources fail.  The active node stays up, active and accepting requests.  On the surface it looks like a...

No, I don't think that that is the case...  They are not tied to the domain and the cluster itself doesn't fail.  Everything still looks good in Cluster admin.

Connections are...

In my experience, an unpatched instance of SQL Server 2000 will not start.  Specifically, the sql server service starts and stops right away.

This particular instance is unpatched, installed on windows...

Thanks again for the replies.  Both good points.  However, they don't address the core question.  Specifically, what changed between Windows 2003 and Windows 2003 R2 to allow SQL Server 2000...

Thanks for the replies.  Please don't misunderstand me, I have no intention of leaving this server unpatched.  I only meant to highlight the fact that the behavior I was seeing...

Interestingly, there is no footnote on this page to indicate SP3 is required for Windows 2003 R2...

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

A typo?  A Deliberate change?

-Dan B

One thing I like to do when feeling especially nervous about updates to a production table is run a SELECT with the WHERE clause I will use in my update or...

A little past a place where there is CollationID, there is a password field of some kind... GPASSWORD

I wonder if this is the password or mediapassword option when calling BACKUP...

Yeah.

Take a backup file, preferably a small one, open it in notepad and have a look around. There is a lot of the jumbled mess you might...

Thanks for the reply Noel,

I actually started with that, but it doesn't work that way either. 

I was using dynamic sql to see if that might provide a solution. 

Update-

I...

We are working on an IDS, but it is not in production yet.

In the meantime, I am learning a valuable lesson about assumptions.  I am accustomed to the fact that...