XPost: microsoft.public.sqlserver.programming   
   From: genew@ocis.net   
      
   Dear SQLers:   
      
        I have a couple of problems with Edit Top 200 Rows.   
      
     1) I call it up on one table, change one column value (not a key   
   column) from "Cheque" to "Check".  When I try to exit the row, I get:   
      
   No row was updated.   
      
   The data in row 3 was not committed.   
   Error Source: Microsoft.SqlServer.Management.DataTools.   
   Error Message: The row value(s) updated or deleted either do not make   
   the row unique or they alter multiple rows(2 rows).   
      
   Correct the errors and retry or press ESC to cancel the change(s).   
      
   and an OK button.   
      
     2) After I have run Edit Top 200 Row and have closed it, I can not   
   rerun my database creation script because the database is supposedly   
   in use.   
      
        Have I done something wrong, or is this a bug?   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)