If only you had that (old) backup. With full logging, all could be restored to the point where you dropped the object(s).

(then you could restore to an alternate db with...

It surely would, but I would like to have some alternatives, because of # of clients using BO.

e.g. Windows aliassing the server. But I cannot seem to get to the...

-dbcc updateusage can help out. statistics get a bit messy when you use truncate table every now and then.

-then dbcc spaceused your db and look for fragmentation rates.

-make sure you...

Do you have (not simple) logging ?

maybe log-explorer (lumigent) or log-pi can help out ?

or http://www.logpi.com  

you could use xp_logininfo, but imo you'd better use the security-capabilities of sqlserver.

e.g. grant a nt-group as db-user and then grant it the needed (sp) rights.

because then you avoid over-authorised...

isn't that (Being lazy) one of the top prerequisite to become a sysadm/dba

my 2€ct

- post ddl ! tables and indexes

- remove functions from your predicates if you can (they wil...

there is an issue with using windows-accounts as job-owner.

I don't know the kb-no by heart. I'll add it if I find it back.

If I'm correct it was http://support.microsoft.com/?kbid=233161

profile, profile, profile and don't forget index-tuning-wizard.

There has to be a reason for this latency.

Maybe an other clustering index can help out. Choose it wizely, based upon your usage info.(profiler,...

check smtpmail (http://www.sqldev.net)

BEGIN TRANSACTION           

  DECLARE @JobID BINARY(16) 

  DECLARE @ReturnCode INT   

  SELECT @ReturnCode = 0    

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1...

So how would you  determine when it's appropriate to run ?

Keep in mind you are preforming an in-transaction-operation.

What you are stating is that with your trigger, all other I/U/D-operations...

oops ... I interpreted "issue" as "error"

The degradation because of plan-recompilation is an "issue" which should not be a problem. The rebuild index should be able...

you can use dos variables to create your directories (one a day) and the move the bak-files to it.

I didn't mention it earlier, but you can have sqlserver managing your...

not that I know of.

Check "rebuilding an index" in BOL.