The SQL Agent service account only needs local admin rights if you want it to automatically restart SQL Server or SQL Agent if they fail.

Getting services to restart automatically on...

The answer is NO. I think it will never happen while MS also sells Windows.

My 2 cents on some of the reasons...

1) SQL Server is closely tied into the...

You will need to import the documents to a column in a SQL Server table before SQL Server can create a full text index on them.

Alternatively you can use Windows...

There is no desperate need to reinitialise tempdb.

Unless your applications do non-standard things that leave objects permanently in tempdb, the space will get re-used automatically. If your...

You may find http://www.codeplex.com/SQLServerFineBuild useful. I published this to help provide a 1-click install and configuration of SQL Server 2005. It includes a section on upgrading from SQL...

Having rights to access the SQL binaries makes no difference to you being able to start/stop the SQL services. You need the following rights on the SQL Services, which...

I always install SQL Server 2005 by copying the install media to a disk on the server, so the install runs locally.

You may find http://www.codeplex.com/SQLServerFineBuild helpful. I published this...

If you are looking at MSDN, also take a look at TechNet. A TechNet Direct subscription is cheaper than MSDN, and give you access to all the MS server...

You might find http://www.codeplex.com/SQLServerFineBuild helpful. I published FineBuild to help provide a 1-click install and configuration of SQL Server 2005. It has a section in the Reference manual...

I hope you are running in 64-bit mode. 4GB is not a lot of memory, and adding more could do a lot for your performance.

Most people who have been through the migration process recommend you do not do an in-place upgrade. It is far safer to uninstall SQL Server 2000 and do a...

Windows Task Manager shows true results on a 64-bit server. If you want more details than Task Manager gives, download Process Monitor from MS (it is a former Sysinternals...

Take a look at http://www.codeplex.com/SQLServerFineBuild. The main purpose of my publishing FineBuild is to help give a 1-click install and configuration of SQL Server 2005.

However, it also contains a...

The routine sets Page Verify to CHECKSUM for SQL Server 2005. This is a more thorough method of detecting possible corruption than the Torn Page detection.

The options for Torn...

Ian,

I have not tried having both of these specified at the same time. It is possible that both mechanisms would try to start Agent, resulting in at least 1...