SRV001\NM1 is virtual SQL Server name with its virtual ip address, In your DNS alias setup, you may have to configure DEV_AP1\NM1 to point the origial virtual ip address of...

I need some clarification about your servers setup.

1. Do you have two separted clustered servers installation? One installed with SRV001 default instance and SRV001\NM1 named instance, The otehr has DEV_AP1...

I did on some of my servers and in the progress on the rest servers.

Microsoft SQL Server 2000 Service Pack 3a (SP3a) incorporates changes to SQL Server 2000 SP3 that address issues raised by the Slammer worm:

SP3a can be applied to SQL Server...

scotttr,

No Theory, Based on experience and the error message you provided.

Bad Hard Drives?

If you do remember 'sa' password, you can change the registry key to make SQL Server work in mixed authentication mode.

Regedt32.exe --> hkey_local_machine --> software --> microsoft --> MSSQLSERVER -->...

Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

Just as member of 'dbo' seems not enough.

SELECT * INTO Trace_Table_Name FROM :: fn_trace_gettable('c:\MyTrace.trc', default)

See BOL for details on fn_trace_gettable function.

I would try to install MDAC 2.6SP2 first and reinstall SQL Server.

First, try to identify whether data segment full or log segment full. From error message, you should have object id, If the object ID is not 8, data space could...

The database may be upgraded from SQL Server 6.5.

There are quite of number of KBs when searching '605' in Microsoft KB website. Have look to see whether they match with your problems.

What is SQL Server version and service...

bigdmoore & nz_climber

You may want to have a look at

http://support.microsoft.com/default.aspx?scid=kb;en-us;817178&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;280101&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;818374&Product=sql2k

Run sp_who2 to see who are using that datbase.