Actually i had no prefix or suffix invalid character.My problems seems to be the managment studio becuase i want to access SQL Server2012 from my SQL Server2008 console.I had the login with dbo,tat's fine.but when i try to open the table in Design
mode or want to see top200 Rows etc,then i came up with the problem.This problem persists for all tables in my Database,even with empty tables also.
Mehboob_hoo
Member
50 Points
55 Posts
Re: Invalid prefix or suffix characters.
May 05, 2012 05:28 AM|LINK
Hello Chen Yu,
Actually i had no prefix or suffix invalid character.My problems seems to be the managment studio becuase i want to access SQL Server2012 from my SQL Server2008 console.I had the login with dbo,tat's fine.but when i try to open the table in Design mode or want to see top200 Rows etc,then i came up with the problem.This problem persists for all tables in my Database,even with empty tables also.
Thanks