Sometimes in SQL 2000 you can end up with two tables that are named the same, but have different owners. So when you view in Enterprise Manager, you may be viewing the table owned by dbo, but when logged into query analyzer, you may be viewing the table owned by joeblow. my blog