And one more question.

SQL Server job in step 1 is calling stored procedure that

accesses DB2 and SQL Server linked servers

and that job is running OK.

I checked SQL Server Agent Connection...

Nothing else.

No Local Login/Impersonate/Remote login.

Nothing.

Just "...be made using this security context..." is checked.

I checked Security Tab for linked server.

This is selected:

Does it mean if I'm not connected to SQL server as "niadetl"

my connection...

My mistake.

I had to move each file.

This works....

RESTORE DATABASE Commission_T59_DSL

FROM DISK = 'D:\MSSQL\Backup\Commission_T59_DSL.bak'

WITH RECOVERY,

STATS = 1, --% completed

MOVE 'Commission_T59_DPH_Data' TO 'D:\MSSQL\Data\Commission_T59_DSL_data.mdf',

MOVE 'commission_t59_DSL_1_Data' TO 'D:\MSSQL\Data\Commission_T59_DSL_data2.mdf',

MOVE 'Commission_T59_DPH_Log' TO 'D:\MSSQL\Data\Commission_T59_DSL_log.ldf',

MOVE 'commission_t59_DSL_1_Log'...

I got it.

Thank you so much K. Brian Kelley!

(Long Live SQLServerCentral.com)

"...a member of the targetserver role in the MSDB database."

Member of which role?

Systems Administrators

Security Administrators

Or is any role?

MANU,

So to be able to view the jobs and all database objects you

say I need to be db_datawriter & db_datareader.

But that means I will be able to do INSERT and...

Check syntaxes

GRANT READ ...

GRANT EXE ...

where?...

I'm doing it through GUI.

Do you mean I should create an account

through T-SQL?

I've never done it.

Can you give me examples?

Guys!

The problem was that on the Network Switch for the port the server was connected to Speed was hard-coded and there was some fixed value.

I think it was 100 Mbps

On...

Another interesting detail.

SET STATISTICS IO ON

gave these results:

PROD (SQL Server 2000)

-----------------------

(2682 row(s) affected)

Table 'luRRs'. Scan count 1, logical reads 52, physical reads 0, read-ahead reads 43.

Table 'LuPersons'. Scan count 1,...

So if it's IO what WAIT_TYPE I would see?

So to summarize it maybe 4 things:

1. IO (data off disk)

2. Lock or latch to be released

3. May wait for a memory grant

4. may wait for some time on the...

I actually selected "Include Client Statistics"

and it looks like the problem is always with "Client processing time".

On PRD it's 200-300. On DEV box it's thousands.

That's what's taking so long to...

I Remote Desktoped to this DEV box,

connected to the LOCAL server and ran exactly the same query.

Elapsed Time is 193 ms.

From my PC Elapsed Time is always more than 7000...

I did a small test.

I wrote a small loop:

and...