MSSQL Error :: Invalid prefix or suffix characters. (Visual Database Tools)

[David@accuwebhosting]

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.