Michael,

Thanks, this has helped me understand a lot of things.

Terry

>I bet you're using the Open Table feature of the Server Enterprise Manager. Remember that SQL Server doesn't have row by row manipulations without the user of a cursor. When you make changes to data in this window, the SEM submits a query to make the actual change. Your problem is caused by a lack a Primary Key which causes more than one row to be modifed, which the SEM throws as an error.
>
>-Mike