Post reply

Table data modification using Enterprise Manager

  • February 6, 2004 at 6:55 pm

    #160736

    I am new to SQL Server. I used the Enetrprise Manager to create a new database and then created a single table within this database. Then I opened this table in the datasheet view (as we refer to this in MS Access) and tried to enter data for the 1st record. When I close this datasheet view window of the table I get an error "Such transaction can not be completed in firehose mode." I would appreciate if any one can let me know if there is a way to enter data into a table using the Enterprise Manager (without using SQL INSERT command).

    PK

    Notelease ignore this message. I see some threads already there on this issue.

  • February 9, 2004 at 12:40 pm

    #493294

    I've never actually run across this. I wonder though if it is due to you not having a primary key on the table?

    Can you script your table out for us so we know the exact steps you used? Also, what version of SQL Server are you using?




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

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

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