200 R2 "200 row edit" error

Results 1 to 5 of 5
  1. #1
    Banned Elinee is offline
    BannedRank
    Jan 2013 Join Date
    68Posts

    smile 200 R2 "200 row edit" error

    Hello

    When i try to edit a table with 200 rows i get the following error:

    Invalid prefix or suffix characters. (MS Visual Database Tools)


    i allready googled about it but can't fix it :s

    Thanks, and sorry for my bad english :p


    EDIT: 2008 R2
    Last edited by Elinee; 27-01-13 at 12:30 AM. Reason: 2008


  2. #2
    Proficient Member Canic is offline
    MemberRank
    Feb 2010 Join Date
    159Posts

    Re: 200 R2 "200 row edit" error

    I think you talk about MSSQL?

    Use a new Query and this Code:

    Code:
    UPDATE [DATABASE]..[TABLE] SET [COLUM] = 'VALUE'

  3. #3
    Banned Elinee is offline
    BannedRank
    Jan 2013 Join Date
    68Posts

    Re: 200 R2 "200 row edit" error

    Hmm im getting errors when i try to do that ;(

  4. #4
    Member androideCF is offline
    MemberRank
    Dec 2009 Join Date
    73Posts

    Re: 200 R2 "200 row edit" error

    that's a problem with versions in MS SQL server. You need to update and patch your operating system and apply all the patchs from MS SQL server 2008 r2.... OR

    when I got that error, I chose to install SQL Express 2012 and everything worked better.

  5. #5
    Banned Elinee is offline
    BannedRank
    Jan 2013 Join Date
    68Posts

    Re: 200 R2 "200 row edit" error

    Well i can't fix it i tryed to update to SQL 2012 but then i get other errors :/


    Can someone add me on skype Q.Q



Advertisement