Wanted to thank everybody again. This refresh worked perfectly last night.

Restored FULL Backup

Restored 8:30pm DIFF

Restored each log after the DIFF completed and VOILA! was able to restore to...

Yes, I can see where that confusion lies. My apologies. I am trying to restore to a point in time that happens to be in the middle of a...

Thank you, both.

I am using LiteSpeed with TSM and the error is:

Msg 60000, Level 16, State 1, Line 0

An error was received while reading backup file- Cancelling

RESTORE LOG...

Because my brain isn't properly functioning, today...

:hehe:

You all are totally awesome. Got what I needed! Thanks so much

Thanks! I was hoping to be able to do it all with one script. But REPLACE might be the way to go.

Appreciate the help.

Nevermind. I apologize for wasting people's time. If Mods see this, please delete.

I didn't search the forum thoroughly enough. Found my answer

Jeff Moden (9/20/2013)

---

From a data security aspect, I'd really want to know why that's necessary. ...

David Webb-CDS (9/20/2013)

---

Haven't tried this, but you could set them up with the db_datareader role in the Model database. When Model is copied as the basis for any new...

Lowell, thank you very much! I am investigating the table option as well. Truly appreciate your help!

Sean Lange (4/6/2012)

---

I may be a little late on this one but I would suggest you use @@servername instead of db_name(). This has bitten me a couple times in the...

nevermind my above (stupid) question. I see how it works. Thank you!

Your table example deals with inserted and deleted rows. I am looking for the before image and the after image of the data on an update.

How would I isolate...

The permissions shouldn't be an issue. The application uses one ID, I can easily add to the DatabaseMailUserRole.

Lowell (4/6/2012)

---

how many columns are"critical" that you have to track for changes in the table to be emailed?

It would be pretty easy to modify my example, but i'd like to...