Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #173
| From | Gene Wirchenko <genew@ocis.net> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming |
| Subject | SSMS 2008: Confusing/Incorrect Error Message |
| Date | 2011-04-13 13:20 -0700 |
| Organization | A noiseless patient Spider |
| Message-ID | <tr0cq615m5r4281lcmvnknsj430ossi3u0@4ax.com> (permalink) |
Cross-posted to 2 groups.
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
Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar
SSMS 2008: Confusing/Incorrect Error Message Gene Wirchenko <genew@ocis.net> - 2011-04-13 13:20 -0700
Re: SSMS 2008: Confusing/Incorrect Error Message Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-13 22:56 +0200
Re: SSMS 2008: Confusing/Incorrect Error Message Gene Wirchenko <genew@ocis.net> - 2011-04-13 14:07 -0700
Re: SSMS 2008: Confusing/Incorrect Error Message Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-13 23:23 +0200
Re: SSMS 2008: Confusing/Incorrect Error Message Gene Wirchenko <genew@ocis.net> - 2011-04-13 17:18 -0700
Re: SSMS 2008: Confusing/Incorrect Error Message Erland Sommarskog <esquel@sommarskog.se> - 2011-04-13 23:50 +0200
Re: SSMS 2008: Confusing/Incorrect Error Message Gene Wirchenko <genew@ocis.net> - 2011-04-13 17:26 -0700
csiph-web