if you assign the value to date first:

ie..

@date = Getdate()

DATEADD(day,2,@date)

this should work.

Ive found you can get more functionality out of MSDE 2000 than sql express 20005, especially due to there being no agent on 2005.

DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow. TRUNCATE TABLE also deletes all the rows in...

To setup a trace that only views the last hour but does not run out of space requires the following:

15:00

JOB1-Step 1- The trace script (set to stop after an hour)...