Groups > comp.databases.ms-sqlserver > #177

Re: SSMS 2008: Confusing/Incorrect Error Message

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSMS 2008: Confusing/Incorrect Error Message
Date	Wed, 13 Apr 2011 23:50:35 +0200
Organization	Erland Sommarskog
Lines	47
Message-ID	<Xns9EC6F28BB1A38Yazorman@127.0.0.1> (permalink)
References	<tr0cq615m5r4281lcmvnknsj430ossi3u0@4ax.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="8925"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1++LXI/tiYAReKtR0PUs0Mu"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:20MlkdfMZXVLVeR0v+dSM9JS7Kc=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:177

Cross-posted to 2 groups.

Show key headers only | View raw

Gene Wirchenko (genew@ocis.net) writes:
>   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.

I don't that grid, and make all my data modifications with scripts. 
Scripts can be reusable. And trying to second-guess SSMS which has 
some funny quirks, is nothing I like.

Hint: you learn more SQL, if you use scripts.

I can say whether the error message you got makes sense or not, since
I don't know the table or the data.

>   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?

I would guess this is regular connection pooling. That is, the client
API holds the connection for 60 seconds after disconnection so it
can be resued. This is nothing specific to SSMS.

The way out is

ALTER DATBASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

That kills all connections against the database.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

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