Sure you are right-clicking on a stored procedure since the menu is context-sensitive?

if you use AWE you have to set memory SQL Server to a fixed amount (no dynamic allocation)

second you can't rely on the taskmanager to view its memory usage, use...

1)Where exactly you have that BOF EOF is true?

2)Try to name your field instead of using .*. This prevents returning unwanted columns, being more clear of the fields requested.

2)Try specifying...

Have you rebooted the OS between changes?

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

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...