You get the value from the "INSERTED" trigger. Meaning something like this:

create trigger ...

for update

as

update audit_table

set val = i.val

from inserted i

where i.table_id = audit_table.table_id

There have been great suggestions in this thread, but I'd submit that your hardware is likely very underpowered for this setup. If you really have that many connections, you need...

Are you restoring a new db on both servers? Or an existing one on the old server? Also, are these from local disk for the backup file?

Does seem a little...

I'd agree with Jeff on that one. It gives you real world situations and problems that you have to solve.

Getting a book and working through it will help as well....

I don't have a complete list, but here's some reading on the topic.

http://www.sqlservercentral.com/columnists/sjones/worstpracticedetaileddisasterplans.asp

http://www.sqlservercentral.com/columnists/sjones/2744.asp

http://www.sqlservercentral.com/columnists/sjones/incidentresponserespondingtoanincident.asp

You'll never keep up with specific plans. The important things are to practice restores, so you have confidence...

I don't think you can do this. The database needs to finish recovering.

Do you know if it's in roll forward or roll back? Check the error log.

Stephanie,

While I agree that someone should have noticed backups failing, I can see the problem there. How does a network admin check the backups?

he looks for failures. You'd need some...

That's a great song. Remember hearing it for the first time, 1987, driving to UVa after summer vacation.

I don't know Scott, ever seen "Office Space"

It's not entirely fiction. I've seen people go through careers without really knowing much

Quotes a little flaky. I prefer to use quotes

Bob said "Steve's opinions are stupid"

I agree.

OK, I didn't want to our anyone with the editorial, and it was somewhat in humor, but seriously. Aren't there more complaints about SQL Server? I was hoping for some...

...

And you can get anything you want,

at ...

Take out the statements in the SELECT list one at a time and see when it works. Then you'll know which line it is breaking on.

Bob,

The problem is that you need to restore the log, but only up to before the delete occurred.

I would have restored the full to another database and copied the data...

Not a BI person, so I can't respond. I have pinged the author on this.