bob_fazio,

thank you so much for your help. i'd really appreciated.

Sorry for the Long post....here it goes. That is wat you want to see i guess.

But I can't see anything wrong with that.

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

Job 'usp_DBCC_CHECKDB' : Step 1, 'usp_DBCC_CHECKDB' : Began...

the funny thing is it dbcc checkdb all the DB without any errors.

DECLARE @dbid int, @DBName sysname, @sql nvarchar(4000), @version char(1)

SELECT @dbid = 0, @version = CONVERT(char(1), SERVERPROPERTY('ProductVersion'))

IF @version = '8'

BEGIN

 WHILE @dbid < (SELECT MAX(dbid) FROM master.dbo.sysdatabases...

are you talking about this msg?

The job failed.  The Job was invoked by Schedule 192 (usp_DBCC_CHECKDB).  The last step to run was step 1 (usp_DBCC_CHECKDB). 

no.

But this doesn't mean testing with SA causes the sql job to fail.

i dunno how many hours took. But the next morning was alrite again. As you said the slowness diminished.

Somoething to do with syspermissions i guess as it stops there. the funny thing is when i run the SP on QA it's all good, no errors at all on...

its 2000

sql server and backup drive are on the same place. There is no mapped drive.

i get something similar to this. someone come up with an answer.

1

jeff, thanks

how can i  just select the word next to w,e,s,n?

avenue,road, circle, crossing