Post reply

cannot edit tables in SSMS when set nocount is on for connections

  • November 6, 2006 at 1:41 pm

    #175102

    This is a strange problem over which I pulled my hair for two days. Fortunately, my colleague found a blog which faintly refers to the solution . I am posting it here so that if you anybody comes across this problem they don't have to waste their time.

    Here is the problem: In SSMS, right-click on a table and choose Open Table. The records in the table are shown in the grid. When nocount is on for connections, you cannot edit those records using keyboard and mouse but you can update the records using update sql!!! This hold sfor all user tables in all databases, even sa cannot edit those tables using SSMS!

  • November 6, 2006 at 2:02 pm

    #670181

    That would be a big oops... hope it'll be fixed in SP2.

     

    Thanx for letting everyone know about this .

  • November 7, 2006 at 11:29 am

    #670348

    ... and yet another reason to go back to the 'old' mentality (pre v7.0) of waiting until SP2 for a given SQL release is 60 days old before implementing the new version ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

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