You have just found the reason that no other application should ever touch a database file except for SQL server. This feature is not unique to SQL Server, most Client...

One trick I have found speeds this kind of query is to move most of your Where clause items to the ON expression for that table, so:

...

FROM dbo.procs a

 INNER...

You can try:

UPDATE CASH_CHECK

SET CASH_CHECK.COMPANY_ID = CBP.COMPANY_ID

FROM CASH_CHECK

 INNER JOIN CASH_PMT_ENTITY CPE ON CASH_CHECK.N_CCHK_OID=CPE.N_CCHK_OID

 INNER JOIN CASH_PMT_DETAIL CPD ON CPE.N_CPD_OID = CPD.N_CPD_OID

 INNER JOIN CASH_BATCH_PMT CBP ON CPD.N_CBP_OID = CBP.N_CBP_OID

  AND CPE.C_OID_SYS_SRC IS NULL

WHERE...

SQL Server 2000 UniCode nchar, nvarchar, ntext datatypes allow you to store the chinese characters.

I am not a Reporting Service expert, but I suspect that the user will only see...

Check out the script for an example of how:

http://www.sqlservercentral.com/scripts/contributions/1522.asp

Andy

For SQL Mail:

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

Check out GFI Network Server Monitor, for a better approach, IMHO.

http://www.gfi.com/nsm/

Andy

You can also use the Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0

http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

Andy

Make Sure that the MSSQLServer and SQLServerAgent service accounts have permissions to access @fileString path.

You can check out this script for more info:

http://www.sqlservercentral.com/scripts/contributions/763.asp

Andy

SQL Server Security: Dealing with Anti-Virus Programs

http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritydealingwithantivirusprograms.asp

This is the best that I have seen.

Andy

The SQL7 download has v7.00.1094 in the name, so perform SELECT @@VERSION

Search the registry for 815495

Andy

I agree for SQL Server, but now that every tom dick an harry app is installing MSDE...

Andy

Watch out for Virus scanners as well, DB, log, trace, etc. files should always be excluded.

Andy

I think that you should post your query and highlight the field(s) that you want to compare.

Andy

You can also checkout products like Lumigent Entegra that use trace files and database logs to audit all SQL Server activity, I have used this and it has even allowed...

I also noticed the diaryentry table structure, if you plan to use the Decimal columns in ADO, you will be best served by CASTing your Decimal(5,0) AS int and Decimal(4,0)...