Change the registry LoginMode to 2 will set SQL Server to mixed authentication mode. If you are lucky, the login "BUILTIN\Administrators" is stil there and you can then login with...

Check KB810185 and hotfix build number is 780.

You can install security fix ms03-031 which includes 780 fix and bring SQL Server build number to 818. Read KB815495.

http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp

Sure you will.

Move everything to node 2

Evict the node 1

Reinstall OS on node 1

Re-join node 1 to node 2

http://support.microsoft.com/default.aspx?scid=kb;en-us;282227

http://support.microsoft.com/default.aspx?scid=kb;en-us;259267

Drop the database HEALTH_DEV and restore production database backup into it with 'move' parameter. For example,

RESTORE DATABASE TestDB

   FROM DISK = 'c:\Northwind.bak'

   WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',

   MOVE 'Northwind_log' TO...

select @@SERVERNAME

or

From control panel --> service, you will see named instance server like MSSQL$ABC and default instance like MSSQLSERVER.

The 64 Bit CD has sp3 builtin. What you need to do is to install security/hot fixes if you need them.

Try to educate them even though it is not that easy.

With 13Gb databases, I agreed with Steve's and It doesn't look like memory leak.

Table hint is the only one.

Have you tried to rebuild the index?

Try update statictics using "UPDATE STATISTICS" with fullscan option.

Do both tables have same number of records?

As long as there are either primary or unique constraint defined in specific columns, you will not be able to insert duplicate data in these columns.

Turn on "ignore_dup_key" controls what...

How large is your database? How many databases in same SQL Server instance and what are the total size of databases?

What is SQL Server service pack level? It could be...