Re: Modifying Data Directly through Studio Manager
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 10 Aug 2006 22:09:24 +0000 (UTC)
Isaac (Isaac@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Since this isn't the forum for business philosophy, I'll let that part go.
My real concern is the technology side of this.
That being said, I wish it was that easy, and I thought that is how it
is supposed to work. However, if I do as you say ("Edit a field, click
or tab to the next field."), I get an error. It's not one about data
integrety per say, but more a misnomer that "The updated row has changed
or been deleted since data was last retrieved."
I'm the only one in the table, or in the server for that matter. That
leads me to believe that I'm either missing something or, more likely,
there is a bug in the interface. I am running SP1 with all hot fixes
made available through Microsoft Update.
Use SQL Server Profiler, to see what Mgmt Studio actually emits to
SQL Server.
If that does not help, please post the CREATE TABLE statement for
your table, and some sample data that causes the problem. The sample
data should be in INSERT statements.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Modifying Data Directly through Studio Manager
- From: Arnie Rowland
- Re: Modifying Data Directly through Studio Manager
- From: Isaac
- Re: Modifying Data Directly through Studio Manager
- Prev by Date: Re: Maintenance plans not installed
- Next by Date: Re: linked server to sybase
- Previous by thread: Re: Modifying Data Directly through Studio Manager
- Next by thread: Re: Modifying Data Directly through Studio Manager
- Index(es):
Relevant Pages
|
