Is the hint really necessary?

Login failed for user SA is sql authentication.

Sure you haven't changed the password for SA?

Can you login using windows authentication?

Also have a look at the CASE statement (acts like an if).

Also consider splitting up your processing to set-based solutions.

example:

SELECT 'ABC' WHERE myfield1='A'

SELECT 'DEF' WHERE myfield2 ='B'

SELECT

   CASE myfield1='A'...

syntax 2 has more chance to perform better and it is more readable.

since you use inner joins, you could trim it to

SELECT RTrim(CONTACT.LName) + ', ' + CONTACT.FName AS 'Contact...

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

...