- Logical dataconsistancy is a user problem.

- Physical dataconsistancy is a sqlserver problem ! This means a transaction is OK or it must...

Is this executed on a sql2000 sp3a multiproc box ?

If yes : did you install the hotfix for count(*)  ?

Microsoft Knowledge Base article number Q814509

"FIX: A Parallel Query with a...

No, because then you would have inconsistend data !

keep in mind the security restrictions for job-alters. Don't run your app with sa-permissions!

declare @NewDate as int

declare @NewTime as integer

declare @dtNewTime as datetime

-- wait for 45 minutes

set @dtNewTime = dateadd(mi,45,getdate())

select...

did you create a full-text-index ?

- Are your stats up to date ? (can you execute sp_updatestats / dbcc updateusage )

- I'd start off with all indexes which have a minor filter ratio (cardinality).

- you...

can you post the DDL for the table and the view so we can see what might be goin wrong ?

Don't ask for my picture, WWF may might just publish me as "endangered species"

My Girls are 40  ...

- 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...