-
SQL ce 2005 Problem
Hi, I was using VS 2005 and move to VS 2008. When I upgraded my app from VS 2005 to VS 2008 my DB was also upgraded to SQL ce 3.5 but can not do anything to it using the SQL Server Management Studio, it does not open even though I am able to quary it in the Visual Studio but it's limited. I am not able to use sql statement to create a table and if you I use the create table from the server exp I can't reference the table. So I would be glad if anyone know what I should do to be able to work on the db using the Sql Server management studio. Thanks
-
Re: SQL ce 2005 Problem
I think you need SqlServer2008 to use managment studio on a 3.5 database.
There is a 'how do I' video on upgrading and database consequences by Jim Wilson here