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

sorry to fall back in so late ... meeting time

Joining is just a question of good old maths ... sets and subsets.

so, you have full and log-backups up til monday, right ?

You have full or bulk-logged recovery model ?

If you take a new log-backup (incremental), you can restore the full with...

did you enter the fully qualified name in EM ?

'MyW2k3SQL2KServer.theotherdomain.theotherdomainsuffix' ?

add a country-code column to your tables and create a partitioned view.

This way sqlserver may serve you best if you want to avoid dynamic sql.

check BOL

With dynamic sql you might...

have the frist step of your fullbackup doing this :

EXEC MSDB.DBO.sp_update_job @job_name = N'MyserverLog_Incremental', @new_name = N'FullbackupProcedure_Disabled - MyserverLog_Incremental', @enabled = 0

and add a last step doing :

EXEC MSDB.DBO.sp_update_job...

Take a look at Intervention system for runaway jobs 

it needs to be updated for sql2ksp3. But it might get you on track.

- compare execution plans !

How is this one doing  ? (don't like it myself but give it a try  &nbsp

That's what you get when your interviewer only has his/her mandatory-questions-list but without a clue what it's all about

"Is it possible that the insert trigger is firing prior to the commit tran? "

Yes !

the trigger is launched at command-time ( insert...

- backup your transactionlog !

Do you have a fullbackup taken before this incident, to which the logbackup can be applied ?

If yes, restore the fullbackup with another dbname using the...