You Receive Errors When Connecting to MSSQL 2012 Using MSSQL 2008 or 2008 R2 Management Studio.
When connecting to SQL server using MSSQL 2008/2008 R2 you receive the following errors:
- Error message received when right-clicking on a table in database - Index was outside the bounds of the array:
- Error message received when clicking Design - This backend version is not supported to design database diagrams or tables:
- Error message received when clicking Edit Top 200 Rows - Invalid prefix or suffix characters:
The server you are connecting to is using SQL Server 2012. The error is a result of incompatibilities with previous versions of SQL Server Management Studio i.e. 2005, 2008, & 2008 R2.
You will need to download SQL Server 2012 Management Studio to make changes to your database. You can download it from the MSSQL Express 2012 website.