Unable to edit data in table in Management Studio 2005

#31

Yes, I'm just glad I was able to find the reason it was doing it... I
knew it wasn't just random...

Thanks for hanging in there with me!

Cheers!

Lonnie

*** Sent via Developersdex http://www.developersdex.com ***

#32

Erland Sommarskog (esquel (AT) sommarskog (DOT) se) writes:

Quote:

However, there are tools that do make use of the rowcount, and apparently
Open Table in SSMS is one of them.

But I would agree that it's kind of crappy. Since it depends on it, I
think it should turn off SET NOCOUNT to avoid this situation. I will
need to research a little more in newer version, and possible enter a
Connect item. Not tonight though.

I researched this a little more. First, I did not read your message
carefully, but I thought it was a setting for SSMS you had changed.
Infact it is a setting for the entire server. If it had been SSMS's own
setting, it would be bad if it tripped itself. But I don't think it
is common to set the "user options" configuration option, so this
seems like a marginal case.

Furthermore, when I tested in SQL 2008 R2 I was not able to repeat the
behaviour. It seems that SSMS 2008 always read back the data and does
not rely on SQL Server returning any rowcount.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Unable to edit data in table in Management Studio 2005

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Unable to edit data in table in Management Studio 2005 - 11-12-2009 , 06:12 PM

Re: Unable to edit data in table in Management Studio 2005 - 11-14-2009 , 05:05 PM