Hello,

Sometimes you should get error of Invalid prefix or suffix characters. (Visual Database Tools) in MSSQL Database.

Reason for this error:

The Query and View Designer options have incorrect characters for either the prefix or suffix. You cannot use the escape character as either a parameter prefix or suffix character.

Solution of this error:
  1. Use prefix or suffix characters that do not contain the escape character.
    OR
  2. Change the escape character.


Regards.