Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot delete a row in a table

Status
Not open for further replies.

maupiti

Programmer
Oct 27, 2003
240
US
SQL 2000 SERVER

In SQL SERVER Enterprise Manager.

I have a table, and this table has no primary key
or index key defined, and it does not have any relationship
with other table. When I try to delete a row it gives me an
error.

Error: Key column information is insufficient
or incorrect. Too many rows were affected by update.
 
Probably better to ask in forum183 (SQL Server: Programming).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top