- did you take a look at locking ? maybe http://www.sqlservercentral.com/scripts/contributions/826.asp can help out.

- Maybe executing the sql with (nolock) hint will deliver sufficient data.

         (be aware of uncommitted data...

case when yourcol between x and y then 'xy'

        when yourcol between a ane b then 'ab'

     else 'not between'

end

update yourtable

set yourcol = replace(replace(yourcol,'2','"'),'1','!')   --

where yourcondition

Check out "replace" in books online

Contratulations Frank. 

Must be at least 64-bit 8-way

Enjoy these...

- Is the schedule active ?

- who is job-owner ? (and is cmdshell open for non-sysadms (don't if not explicitly needed !  )  ?

- does the sqlagent service account have...

what's in de error-collection of bds after the bds.open ?

err.message, ...

Don't use the copy database wizard because it detaches the source-db for a while (and reattatches it).

You may want to consider using restore using UNC.

Restore database MyDb

from DISK = '\\myserver\disk$\msSQL\BACKUP\mybackup.BAK' 

 with...

No Idea.

check :

- windows event logs

- sqlserver logs

- sqlagent logs

That's why you 'll want to have your clustering keys as small as possible.

All your NCI's will be affected because they nolonger...

Check out Gert's article : 

http://sqldev.net/articles/WaitTypes.htm

- can you post your restore statement ?

- can you post the execution report containing the error(s) ?

only sa can run jobs he/she does not own.

you might consider a workaround using alerts which launch the wanted job.

Are there other users in the db/tb when you run your test(s).

Because you are performing another tableaction

SELECT MIN(PremInstalmentDate)

          FROM tblPremPolicyPremium

          WHERE PremPoliID = PoliID

           AND PremDeleted = 'N'

           AND PremIncludeInTotal = 'Y'

          GROUP BY PremPoliID

January 19, 2005 at 8:10 am