I tend to agree with Matt, pick what makes sense for you.

Heck, if you're getting reimbursement, go for both. An MBA with concentration in MIS probably gets you a long...

It just runs sp_delete_backuphistory.

You can profile it, but the easiest thing to do is hit the View T-SQL button on the task. It shows you what runs.

Me, too. I'll grab my resume, err coat and meet you downstairs 🙂

It pays to test your restores regularly, but I'm not sure I'd test everyone. The SQL backup to...

select a.first_name, b.last_name

from table a, table b

order by new_id()

I think I'd do something similar to what you're doing. I might create a real table, populate with the data + SPID perhaps, extract batches of 300 from there. Maybe...

This should be a list of options set for the database. Is there something set differently on that database?

You can look at the code for this proc in master to...

This help?

http://support.microsoft.com/kb/271624

You could set some things up, like DDL triggers, but a sysadmin could disable them.

Remove them from sysadmin access if you need to.

The above is correct. Once you've done this, you require a full backup to be able to restore. This should not be a standard practice in production. The TRUNCATE ONLY...

Can you explain what you mean by combine? Run both of them together? Run one of them based on Z?

Please don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic440533-338-1.aspx

Any of the 2005 books are fine. I like the one from Brian Knight, but I know him and he's a business partner.

That's really the only way to make this work. The trigger will always execute as the person updating the table, and it would need rights to the other database if...

Inside SQL Server is here: http://corporate.books24x7.com/home2.asp

I like to stay fairly current, but if I couldn't thoroughly test, I'd wait for SP3. I would recommend if you have an issue fixed in a cumulative pack, get...