You can loop the recordset and execute the stored procedure for each record.

How is the security delegation for linked sql server configured?

Always login using with the user context, always connect with this account ....?

Both are sql server 2000?

Same collation?

Are you sure that col3 on A isn't a timestamp?

That made me curious since we use also Oracle at work.

How do you set the option "Nested Queries" to on?

You could use openquery.

Create a view on oracle that combines both tables?

Are you local client tools also patched to sp4?

select companyid,staffname

from

(select companyid,staffname,1 as sequence

from tblA

where companyid='ABC123'

union

select companyid,stafname,2 as sequence

from tblB

where companyid='ABC123'

) AS mynewtable

order by companyid,stafname,sequence

see http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

it depends on OS & edition

from 32mb of memory to 128

I've found they arrive in SPAM sometimes. Atleast in my Yahoo account

select @@version

According to the books online the xp_msver stored procedure gives more information

That needs some deeper digging.

It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.

Do you retrieve all the records you request instead...

That needs some deeper digging.

It is probably a locking issue. Are you familiar with enterprise manager/query analyer/sql profiler of sql server 2000.

Do you retrieve all the records you request instead...

check out

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

You can shrink the database (reclaim unused space) with

DBCC SHRINKDATABASE

DBCC SHRINKFILE

See the books online for more information.

Have you tried increasing/decreasing max worker threads?