Edit data MS SQL 2005

Posted on 2010-01-07
Last Modified: 2012-05-08
Is it still possible to directly edit data in a table in MS SQL 2005.  If I needed to change one value in 2000, I would create a simple query on that table in Enterprise Manage to display the data I was interested in and then just change the values in the fields.  Is there still a way to do that in 2005.  The only way I have been able to figure out is to open the table and scroll until I find the row I need.  This is very inconvenient.
Thank you.
Question by:sbdt8631
    LVL 75

    Accepted Solution

    you can do it thru ssms, but its not advisable because internally it has to recreate the table
    LVL 60

    Expert Comment

    I think you can, but you are a LOT better off modifying it through script:

    update tablename
    set fieldvalue = 'something'
    where fieldvalue2 = 'something'
    LVL 60

    Expert Comment

    >>because internally it has to recreate the table

    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    >>>>because internally it has to recreate the table
    oopts what i was supposed to mention was about the locks and accidently put recreation, thanks tim
    LVL 1

    Author Comment

    I can do it through ssms if I open the table and scroll until I find the correct record, which is inconvenient when even possible.  Is there a way to limit the records displayed like I used to do in 2000 where I created a query and edited the results of the query.  I prefer not to write an update query for jobs where I only want to change one field in one or two records.  I have a nasty habit of forgetting to include that pesky where clause.  And there doesn't seem to be a simple way to copy a table like there was in 2000 for a simple backup in case of a mistake.
    LVL 60

    Assisted Solution

    you can right click the table and it will return 1000 records or so.  MS got away from what you were doing because it was such a resource hog.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now