I have SQL Server Management Studio 2005 R2 in my administrator PC, and SQL Server Management Studio 2008 in the Server PC. Each time I tried to connect to the database server (SSMS 2008), it will throw errors that indicated I have different version of database or the software or else (db instance some said?).
I had search the internet. The most correct solution was to use Cumulative update package 5 for SQL Server 2005 Service Pack 2 to connect to 2008.
But my questions is, is there any other solution that doesn't need me to update or install any patch for the SSMS 2005 ? Maybe like tweaks or any other fast solution ? Any comments appreciated! Thanks!