This is a simple SQL Server 7 Enterprise Manager question:
I have a table with an identity field and 5 non-identity fields. None of
them are related to any other table. I right-click on the table in the
Enterprise Manager and choose "Open table" and "Return all rows". When I
right-click on a record, the "Delete" menu-item is disabled. I can delete
records fine with the Query Analyzer or through code. Any ideas on how to
enable the Delete?
Thanks,
Eric