are you using ADO's NextResultSet ?

from http://www.windowsitpro.com/SQLServer/Article/ArticleID/27576/27576.html

When I have to extract data from multiple tables, which approach is more efficient: creating one stored procedure that uses ADO's NextResultSet method...

I assume you have set the filtering properly to monitor only that statement on that very specific machine? (to exclude other users)

If you keep getting them double it must be the...

How do you verify it only runs the first step?

I have no background of access newer than 2000.

Probably it is returning multiple recordsets and your procedure only browses the first....

Reapply the service pack, perhaps the installation wasn't succesfull.

select stock.co_id,stock.date1,stock.[open],stock.high,stock.low

from dbo.stock stock

inner join /*only matches*/

(

 select co_id,max(date1) as lastdate

 from  dbo.stock

 group by co_id

) As stocklastdate /*subquery to select on last date for each id*/

on stock.co_id=stocklastdate.co_id

and stock.date1=stocklastdate.lastdate

order by stock.co_id

Try SP:StmtCompleted and SQL:StmtCompleted in addition to RPC:Completed (stored procedures) and SQL:BatchCompleted

in a stored procedure

CREATE PROCEDURE USP_DOSOMEWORK

AS

EXECUTE USP_STEP1

EXECUTE USP_STEP2

...

I don't have experience with powerdesigner. Perhaps you can contact the vendor?

What are CDM and PDM ?

you can accomplish that with the case statement

,case

WHEN gldebitacct IS NOT NULL THEN

     CASE

           WHEN ...

You must be aware that you'll have to reconfigure microsoft transaction coordinator.

See: http://support.microsoft.com/kb/839279

Otherwise I've had no issues.

according to the books online sql 2000 gives

Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

perhaps...

Select the job(s) you want from Management-SQL Agent-Jobs  in enterprise manager

Right click and choose all tasks->Generate script

If it was a long running query it may have an extensive rollback period.

Are there any entries in the OS event-viewer?

Can you connect to the database using queryanalyzer? If so...

Which indexes are currently used by your query (view the queryanalyzer)?

Does the index wizard gives any hints?

select

It could have been that the server was too busy.

Is the user able to open the report now?