i think also that you can inser a checkpoint in your transaction .. so you can restore back to this checkpoint

read more on this in BOL, if this is important to...

did you install SQL Server SP3a ? 

to make path on any other machine write something like this

\\MachineName\D$\FileName.xls

i hope this help u

if your SP take huge time to execute .. then you have to check these options that may help u

1- take care that your SQl server doesn't have any other...

do you have enough Rams on this machine? .. try to increase Rams .. it gives you more performace

what is the Access version you use ? 2000 or Xp (2002)...

Ineed them because i want to review any Design I make ..and any changes i need to make

by the way jgoodwin, the site you gave to me , i don't...

realy i don't know ... you can delete one by one (with seeing names ..) and if problem happened get the one back again

I don't think you have to do...

I think you have to make this indexdefrag after working hourse .. and to kill users who are connecting bewfore you do this (there is a script to make this...

i want to ask ..

what is best ... to check auto update statistics in DB properties .. or to make statistices update by yourself (by maintance plan for example) ?

what about reindex msdb (if you can).. this may solve your problem

what do you meen by inactive extended stored procedures ?

download Log P.I. this may help u to see what you want.

Download a free full evaluation copy now!

if your SP take huge time to execute .. then you have to check these options that may help u

1- take care that your SQl server doesn't have any other...

i think you have to shrink DB after making your Truncate .. or shrink Log after making delete .. so the DB size is less and the space returned to...

what about using DTS wizard ?.. right click on your Database and All Tasks>> export Data

and in the last screen Save your DTS package .. so you can use it...