Also try to monitor the locks on the table. Any transaction taking longer than required?

Drop constraint:

ALTER TABLE table DROP CONSTRAINT constraintname

Describe constraint:

sp_helptext [ @objname = ] 'constraintname'

Greetings,

1. What version of sql server is it and which servicepack do you have applied to it. SP3a or higher is required for sql server 2000 on a windows 2003...

the insert-sequence & select-sequence are out of order

insert-sequence: status at the end

select-sequence: status in the middle

move MAX(CASE WHEN HEADER = 'AFS' AND PROPERTY = 'Membership Number' THEN STATUS...

It should die soon after that. Do you check it with sp_who?

You could use the sql server best practices analyzer on the db. It will report which stored procedures,views needs some work. Like owner not specified ...

Perhaps you will have access...

The process needs to be kept alive till the rollback is completed (which can also take a long time).

Any clues why the vb app suddenly started to work slower?

Can you check if any connections are left open? Maybe there is one with a transaction left open/select pending. (last batchtime in the weeked)

For a custom temporary db, perhaps you...

Make sure the bit-field doesn't allow nulls

Not sure if it may help. I've created a querydef that called a stored procedure. The access-reports recordsource would be then that querydef. Not sure if I've layered another querydef...

Naming in Oracle is a little different.

Try

select count(*) from [linked_servername]..[OracleSchemaName].[Viewname].

Buran Kumar Tiwari,

Can you make a seperate topic of the issue with CSV-Excel, eventually with a link to this post? The logdates showing as 00.00.0, are they displayed as real-dates...

a word-document how to set up an oracle linked server:

http://www.ed.uiuc.edu/datamasters/Documents/GEN_SQLServerOracleLinkedServer.doc

the microsoft way:

http://support.microsoft.com/kb/280106/

seems sql 2000 comparision got replaced with the 2005 version

from the books online (2000)

Features Supported by the Editions of SQL Server 2000

This topic summarizes the features that the different editions...

DELETE ABCD

FROM ABCD

INNER JOIN

(

SELECT ACCTNO,MAX(LOTDATE)  AS MAX_DATE

FROM ABCD

GROUP BY ACCTNO

) AS MOST_RECENT

ON MOST_RECENT.ACCTNO=ABCD.ACCTNO

AND ABCD.LOTDATE<MOST_RECENT.MAX_DATE

should do it