SSMS 2008 Connecting to SQL 2005

When trying to connect to a SQL 2005/2000 Server from SQL Server Management Studio 2008 you will get this error when trying to view the list of databases:

image

There is a very quick way to resolved this.  Click on the “View” menu and select “Object Explorer Details”:

image

Right click the column header and deselect “Collation”:

image

Now refresh the database list and all should be good.

0 comments:

Post a Comment