What are your goals? Do you want to know IF the data changed, WHEN it changed, or WHO (or what process) changed it? Or do you need to track...

I looked in all the obvious places for this functionality once, but never found it. I've since dabbled with SQL DMO (the object, or COM, interface for Enterprise Manager);...

More info leads, as ever, to more questions...

Are you able to tell: does just running update usage cause the query to perform properly?

Can you replicate things by running the processes...

I'm not too clear on the issue/problem you're having. You drop and insert data in table A, and then update A based on B (the inner join). So...

(Cut and paste most of this from a post I made two minutes ago...)

Various internal statistics will get out of date over time, particularly if you're doing a lot...

Various internal statistics will get out of date over time, particularly if you're doing a lot of index-intensive work (such as reindexing). Running DBCC UPDATEUSAGE causes SQL to...

A year-plus later, this thread saved me I don't want to think how much time. Yeah, SQL Server Central!

I've got one more thing to add on to this. I'm...

Disk vs. tape: It's not about backups--it's the restores that count. If they want a database restored, they generally want it restored RIGHT NOW... and you'll get it done...

Just posting to confirm from direct personal experience that everything skeane said is correct. So long as your transaction log backups don't get lost or corrupted, log shipping will continue...

Followup #1: Had to apply this process to 6 developer boxes, so everything became a bit more formalized. Still some bugaboos I haven't figure out, but the process works.

Followup...

Thanks for the positive feedback! I'll give it some thought--but, as you might imagine, just now I don't have all that much free time. To do the subject justice,...

Brian, all that would certainly work, and I'll remember this thread for if I'm ever in a similar circumstance again. As it is I'm playing buttoutsky on this one,...

The SA password is different on ever box.

After talking with some friends--if I've got the terminology right--I believe that they did a migration, not an upgrade. I think this...

Flipping from Mixed to NT only and back again: this would not work. The password is stored in sysLogins, and would not be affected. (Otherwise everyone would use...

JP,

Thanks, but I lack the expertise to perform deft and esoteric (at least to me) manipulation of AD, as does everyone else here. (I could figure it out eventually,...