Ahhh, if I could hide posts...

I regret not building this in early and forcing developers to re-implement it over the years.

Jim has a good explanation. In short

a) backup started

b) transaction committed (insert/update/delete)

c) backup complete.

Anything that happens before the backup is complete is included.

I fail to see how read locks to a temp table or to a user are substantially different. Perhaps you can list? There are huge sites, places like MySpace, the...

I think doobya's approach can save performance if you do app checking since it's more scalable. The DB is a single, shared resource, and anytime you can move cycles off...

Mandating a specific account is a sign of a) poor securty and b) crappy development practice.

We used to use Patrol from BMC at a company, and while it required admin/sysadmin...

I could be a judge! Speedo under the black ghost cloak, pronouncing verdicts!

Too bad it's so hot in LV. My wife did not like that.

Hopefully all speeches are written by then.

Usually I'm meeting people, or slipping into sessions to report on things, or trying to relax and catch up in the convention center. Add...

Not sure. I would have thought that an error would come through, or the permissions dropped.

You ought to be able to script permissons for the old group, then apply...

CirquedeSQLeil (7/23/2010)

WOOT

4...

Sorry, I noted "your managers" at the beginning, but then started writing in "you"

I realize it's not you, and was giving answers that I'd push back to other managers as...

Excellent points, jvanderberg. Often RI is there to prevent accidental mistakes, not malicious ones.

Good luck, Lynn, and hope it goes well.

SQLGuru Dance party? Tango lessons?

At the very least, anyone who attends can ask questions of TheSQLGuru and get some great answers.

Smart phone or smart smoke signals up in Alaska?

VCS

Doing a Red Gate SQL Source Control demo today. I think this is a very cool product.

http://www.red-gate.com/products/sql_source_control/index.htm