Post reply

Management Studio equivelent to Enterprise Manager Data editor

  • July 21, 2008 at 3:20 pm

    #188461

    In Enterprise Manager you had the capability to directly edit data content in the results grid (I know I'm going to be blasted for what a bad thing this is to do, but for single control record changes in a development environment it is much faster that writing a throwaway update query)

    Is there any equivalent functionality in Management Studio ? If so how do you get to it ?

    Thanks

  • July 21, 2008 at 3:26 pm

    #846039

    Right click on the table in the Object Explorer Pane, select Open Table.

    😎

  • July 21, 2008 at 3:30 pm

    #846041

    OK that was easy, but is there any way to limit the grid to a results of a simple query, I hate to have the whole table open for update, if I can limit it to a couple of columns on a few rows.

  • July 21, 2008 at 3:33 pm

    #846043

    Never mind I see where it's going, I was trying to get to it from a query screen, it looks like if you start with the open table, then you can get to the rest of what I was looking for

    Thanks for the clue - (since I was clue-less on getting started)

  • July 21, 2008 at 3:47 pm

    #846051

    Sounds good!

    😎

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply