What are you looking for a replacement for?  i.e.  What features are you wanting that QA doesn't provide?

Did you try putting EXEC in front of proc name?

The problem you are running into is common.  ANYTHING + NULL will always = NULL.

Nicholas has provided how to get around this by changing a NULL field to be a...

Are the server and workstation on same Domain?  IF NO are the domains trusted?  IF yes can you run the SELECT from QA without a problem?

Are you using TCP/IP or...

1.  Build a cube

2.  Build a summary table that gets updated nightly.

I would try putting the servername like [TEAM01\XXXX]

oh..  and please tell me the password supplied is not the REAL one...  IF it is I would probably modify my post and...

Philip has come close to hitting this issue on the head.  Depending on how you connect to SQL either via SQL login or Windows Auth tells the server which security...

I am pretty sure that the problem is that when you switched to ActiveX you now need to EXPLICITLY set the rowcount per step (this was implicitly done with subpackaging).

You...

AFAIK there is no "auto-kill" feature in SQL.  To add users search BOL "user accounts, changing" as 1 example

I prefer the sp_msforeachdb.  This way you don't have to hard-code DBIDs (IF you didn't install pubs/northwind way lose some created DBs)

I would start with what application are you using for the INSERTs (have you checked the timeout or changed it)

Have you reviewed your indexes to make sure no fragmentation, they...

The only way to use ORDINAL positioning is with ORDER BY and it still is not a good idea...

SELECT field1, field2, etc...

  FROM Database1.owner.Master1

    INNER JOIN Database2.owner.table1

????

LOL.  I would like to think that developers/DBAs, etc...  would be allowed the "luxury" of creating a user-defined database for storing common sp's but you always have the bean counter/capacity...

Research BOL for sp_startjob