When I open a table using Enterprise Manager (right-click on table name, then select "open table", then "return all rows"), I can insert or update all tables.
However, when I open a table using the Object Browser in Query Analyzer (right-click on table name, then select "open"), some tables do not allow me to update or insert rows.
Why is there a difference?
I am using Windows authentication to connect to the SQL Server in both Query Analyzer and Enterprise Manager.
My Server Login is assigned to the System Administrator role, and db_owner role in the databases.