Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
Error - Invalid prefix or suffix characters. (MSSQl Server)
Posted by on 27 December 2012 10:45 AM

You receive an error when you Right Click on any table and choose "Edit Top 200 rows"

 

Error - Invalid prefix or suffix characters. (MS Visual Database Tools)

 

This is known issue with SQL Server 2008 R2 Management Studio while connecting to SQL Server 2012.There are no claims on what features may/may-not work, and this is expected behavior.

 

There were errors in basic connectivity and those have been fixed in the past.

For example, http://support.microsoft.com/kb/2459027/EN-US (FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008)

 

FIX:

To use all features of SSMS, use the same version as MSSQL Server engine (i.e. MSSQL Server 2012 / MSSQL Server 2012 Management Studio Express)

(17 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).