Re: Modifying Data Directly through Studio Manager

Not text, but varchar. Enterprise manager (in SQL 2000) never had a problem
modifying varchar, int, decimal, float, etc.

Yes, I am using SSMS to remotely manage the server. Also, just to rule out
security, I've tested this while being logged in as "sa". No difference.

"Arnie Rowland" wrote:

You're right, I should have dropped it too.

I'm using version 9.00.2047 (SP1). I have no difficulty in editing and
saving edits to table data.

Let's explore some other reported issues with the same message.

Is there a text datatype field in the table?

Are you using SSMS to remotely manage a server?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Isaac" <Isaac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F579129-E3F8-4E89-A481-A74CDEA17102@xxxxxxxxxxxxxxxx
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.

"Arnie Rowland" wrote:

Because business decision choose to allow this doesn't mean that it isn't
an
troublesome decision, and in my opinion, one that is truly lunacy. It
seems
like a 'Sales Add-on' (read: additional revenue) to provide an
appropriate
'tool' to allow your customers to manage their data.

Yes, I've used it for editing. Edit a field, click or tab to the next
field.
If an error occurs, correct the nature of the error (datalength,
datatype,
etc.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Isaac" <Isaac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:385F1137-8205-4600-96C5-FE885D779512@xxxxxxxxxxxxxxxx
Not idiotic, necessary. We won't refuse a sale because a customer is
not
large enough to afford a DBA. A basic IT person could handle the
Enterprise
Manager, and our customers are entitled to do whatever they wish with
their
data.

I see the "Open Table" option. Have you tried to use it? I make a
change,
click the pen to the left, and I get a red exclamation mark. If I
execute
the query, the change is lost. If I hit enter (instead of clicking the
pen),
it errors out stating that the data has changed since the last refresh.

I've seen people comment on turned on the query pane, but all that does
is
shows me the select statement. If my customers could do TSQL, I never
would
have made this post.

"Isaac" wrote:

HELP!!!! I've been using SQL for years, and I support a product built
on
top
of SQL Server. Many of my customers are starting to upgrade to SQL
2005,
but
the ones that are not "SQL inclined" are having problems modifying
data.
They are used to having simple tables that can have rows modified by
simply
opening Enterprise Manager (in SQL 7 and 2000), returning the
appropriate
rows, entering the new data, and saving the record. From what I've
seen
in
2005, you can't do that.

I understand that Query can be written, but this is for people that
are
much
better with an "Access" environment, if you will. I've seen a lot of
posts
on this on other sites, but no solutions. Fellow MCSE's, I'm calling
on
you
to help!!!

Thank you,

Isaac Shloss, MCSE






.

Relevant Pages

  • Re: Windows Authentication or SQL Server Authentication
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... then go for Windows Authentication. ... I have a new software package that is running on SQL 2005 Standard. ...
    (microsoft.public.sqlserver.security)
  • Re: NIC settings for SQL 2005 and windows 2003?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... It would seem so, but this fellow Microsoft MVP in SQL, say's that isn't ... always use the ""Maximize date throughput for file sharing" setting. ...
    (microsoft.public.sqlserver.connect)
  • Re: Schema Problems
    ... So there's no secure way to allow creation of objects but not deletion of ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... in SQL Server 2005 we have a new feature as DDL Triggers. ...
    (microsoft.public.sqlserver.security)
  • Re: English Query
    ... English Query has been discontinued for SQL 2005, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.olap)
  • Re: Foxpro sql limitations
    ... My application is an online user interface for customers to log on to ... and check the status of their fleet of vehicles (the client is a fleet ... The ASP site connects to the Foxpro database used ... This SQL db has since been expanded to include some more ...
    (microsoft.public.fox.vfp.queries-sql)