I'm not the best at grammar; we all make mistakes. Your misuse of then vs than was confusing. It's a simple matter to spell these correctly. ...

And it doesn't just have to be in the IT area. Try listening to the TED talks (http://www.ted.com/ ). I come away more energized and...

I also read your stuff, although this is the first time I've ever responded to it!.   I'm a DBA that works with 4 different databases and need to maximize time...

These work at my site.  Linked server name is DB2TL

DELETE FROM DB2TL..WFMM.ACCOUNT;

INSERT INTO DB2TL..WFMM.ACCOUNT SELECT * FROM ACCOUNT_V4;

If they aren't working, make sure you are not using the OLE Provider...

Just had this problem and was able to solve it.

The problem is the MS OLE DB driver for ODBC does not allow update insert or delete.  If you switch to...

I've had this problem with Backup Exec when Backup Exec was backing up the folder/file while the DB backup job was running. The solution was to coordinate the EM/Backup...