With Query Analyzer or EM : sp_detatch_db 'yourUserdb'

With explorer move the file to the correct location.

With Query Analyzer or EM : sp_attach_db 'yourUserdb', 'FileLocationAndName.MDF', 'FileLocationAndName.Ldf'

For system databases check http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071

Maybe even...

Antares686 sead it all

- Figure out the average actual datalength of you char columns.

     SELECT avg(datalength(...

- how many rows get into a single datapage ?

- you could rebuild the clustering indexes.

log on to the server using your sqlagent account and then try to run the package from EM\edit dts package.

You'll get more detailed errorinfo.

Great to know I'm not the only one that has those concerns

"...size of the log file and truncates & shrinks it ..."

I hope your DRP can cope with that

We don't use fixed- or max-memory setting on most of our sql2k-servers. Only when experiencing  sql-paging, it occurs we put a max-memory on it.

I believe the recomendation to leave 512Mb is...

that's what I assumed.

Normaly, just the statistics will not cause such log-load.

dbreindex rewrites it all. this log-overhead can be reduced by switching to bulk-logged recovery mode.

switch to bluk-logging before performing your maintenance !

full-logged it logs everything !

take a look at BOL : search for "NOCHECK CONSTRAINT"

alter table myschema.mytable NOCHECK CONSTRAINT myconstraint

don't forget to enable it again when you're done.

correct. Only using EM it will not allow you to do so.

I persume because backups should still be available when failed over

(we...

yep, this time I failed to give the wrong answer

same over here. same remark

select t.taskid, t.staffid,

sum(isnull(datediff(s,wt_starttime,isnull(wt_stoptime,getdate()))), 0) as [timespent]

from task t

left join pt_vCheckworktime

on fk_taskid=t.taskid and fk_staffid=t.staffid

group by t.taskid,t.staffid

keep in mind that your udf will be executed at row-level where the join will...

I even didn't get the chance to reply the wrong question , it was already there for me .... You've already answered this...