Error Invalid prefix or suffix characters in SQL Server Management Studio

sql-server sql-server-2008-r2 ssms
60,874

This happens when you try to edit the top 200 rows of a SQL Server 2012 database using the 2008 R2 SQL Server Management Studio. Upgrade SQL Server Management Studio to 2012 or edit the rows using a SQL query.

Share:
60,874
Renzo Ciot
Author by

Renzo Ciot

Partner at Tempestive S.p.A. I am a software developer since 1998. Most of my work has been with C#, Java, javascript and SQLServer.

Updated on September 25, 2020

Comments

  • Renzo Ciot
    Renzo Ciot almost 4 years

    When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: "Invalid prefix or suffix characters. (MS Visual Database Tools)".

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

SQL Server: How to edit a view without scripting it?
Unable to log in to server in SQL Server 2008 R2 Management Studio
Clarification as to why EXECUTE AS USER/LOGIN is not returning the expected results?
IntelliSense is not working in SQL Server Management Studio
Efficiently checking if more than one row exists in a recordset
Is there any way/tool to identify estimate query run time in SQL sERVER
Hash Table in SQL Server?
How do I sort string alphabetically
How to remove the first column from a temp table select
SQL Server Managemet Studio not finding local server