If you always move all changes, because you don't keep things "in progress" in the development database, then SQL Compare from Red Gate (I work for them) or ApexSQL Diff...

Your match should work. I am guessing that for some reason one of the tables might have spaces or some other non-visible characters that are causing the matches to miss.

Have...

You might check out sqlis.com as well. Not videos, but good articles.

Steph,

Great points about the distractions. I wasn't speaking so much on the noise or motion being distracting as the content distracting you by getting your attention.

If something like this is...

I thought that the big thing with multiple files is that you get a thread per file, so the thread can be assigned and the CPU can move off, waiting...

It's easy to CTRL-ALT-DEL, but think about how many times you might respond to a question and the person says, "hey, come look at this" and your workstation is open....

Have you refreshed EM to be sure it's not old? Also check the error log to see if there's a suspect entry in the log and what the error is.

Kyle, can you show what you'd want returned as far as other data or is it just the max date using some criteria?

Also, show what you've tried. This almost sounds...

I don't believe that you can disable the trigger in a trigger. The problem with Novell doing it could be rights.

However the solution here is probably not to disable the...

I work for Red Gate and their tool has great reviews. Apex's tool is good as well, download both, pick the one you like.

Red Gate has Data Compare as well...

You need to have a column that stores the last change date and use a trigger to ensure it's updated.

alternatively the transaction log will have data in it, but you'd...

I 've never worried about the owner, though in production I've tried to keep it to SA for consistency and to be sure there are no issues.

Here, here, well said, Jeff.

Matt brings up a good point, though for something personal, perhaps it's not that big a deal. It would be better to have VPN, and I mentioned to Chris that...

sp_help_revlogin 🙂