Try SELECT * FROM TSTCMDDB1.master.dbo.usysprocess(51) but it still doesn't work. Same error message.

Edited by - Allen_Cui on 11/14/2002 12:28:14 PM

Go to Enterprise Manager Property --> Security Tab --> Audit Level to verfify.

The query runs much faster than in Query Analyzer.

SELECT SAMPLE.RECD_DATE, SAMPLE.DATE_REVIEWED, SAMPLE.SAMPLING_POINT, SAMPLE.CHANGED_ON, SAMPLE.LAB_, SAMPLE.GROUP_NAME, LOT.LOT_NUMBER, LOT.LOT_NAME, TEST.ANALYSIS, LOT_SAMPLING_POINT.DISPOSITION, LOT_SAMPLING_POINT.DISPOSITION_DATE, PRODUCT.DESCRIPTION, RESULT.STATUS FROM LabWareDev.dbo.SAMPLE SAMPLE INNER JOIN LabWareDev.dbo.TEST TEST...

Running SQL Server 2000 with SP2 on Windows 2000 advance server SP2 with 2 CPUs machine and 4GB Ram. Client runs Crystal Report application to connect to SQL Server via...

I would create MD DTC resource in SQL Server group in active/passive configuration and in the default cluster group in active/active.

Depends on which group MS DTC is in. Generally, it depends on the network name and disk in the same group.

I am not sure whether MS DTC have to to be configured before installing SQL Server. I did it by running comclust after the SQL Server installation.

There are no such Data Modification Rules lised in BOL, Could it be a bug?

Try dbcc inputbuffer if you know the spid.

It looks like your qurey is running in parallel.

You don't need SP1. Suggest you login into the active node with a domain administrator account and try to reinstall the SP2. Make sure this domain administrator account is in...

Try Profiler.

Have you run dbcc checktable to check anything wrong on these three tables?

use msdb

go

sp_helpfile -- find out the log size

go

use master

go

sp_configure 'allow update',1

go

reconfigure with override

go

alter database msdb

modify file

(name = msdblog,

size = 50mb) -- change this...

What is the version of SQLSERVR.EXE?