SSMS 2008 R2 Invalid prefix or suffix characters

[rriggs1000]

I'm getting this message when i right-click to Edit Top 200 on a table that I've used many times before. Other posts mention having an escape in a prefix or suffix or in the table data but i don't know how you would search for an escape. Sometimes when i try to edit it just shows a blank screen without giving me the message. I hope someone can help!

 

[markros]

SSMS is not really a GUI for editing tables. Perhaps you can simply write an UPDATE command

PluralSight Learning Library