Don't know if this was mentioned in any of the previous replies, but I'd add "check indexing schemes" under the "Research" heading. Never assume previous developers have done a...

I'm having the same problem between SQL2005 and SQL2000.

I'm using a standard T-SQL AFTER INSERT Trigger to update data in the SQL2000 database. Did you find a solution this?